EXCEL - dividing by time?? 2

[metalboy]

Ok i have one cell which is a regular number and one cell which is time format 00:00:00. Ok this is hurting my head! I need to divide my number by the time so if the number is calls it tells you how many calls are taken each hour.

Please help guys!

Regards all

Alex

“It is a mistake to think you can solve any major problems just with potatoes.”
Douglas Adams

 

[xlbo]

ok - time is just a format. The underlying data is a decimal number

1 = 1 day
the decimal portion is the TIME of day so
1.5 = 1 day, 12 hours

So...if 1 day = 1 then 1 hour = 1/24
So, if you have say 100 in cell A1 and a time of 01:00:00 in B1 then
=A1/(B1*24)

will do the job

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question

 

[gizmo1973]

= Calls Cell/(time cell*24)
I seem to remeber that from when I worked in a call center that you have to multiply by hours in day, seems to work when I just tested it!!

Regards, Phil.

Full Member of Shareholders United.
Show your true support here:

http://www.shareholdersunited.org/join.php

"M.U.F.C. Not for sale to Glazier"

 

[SkipVought]

Hi,

1) If you are dividing by SOMETHING related to TIME, it must be a DURATION of time NOT a single time value.

I'm not going to divide by 6 o'clock!

But I could divide by 6 days or 6 hours or 6 minutes or 6 seconds.

2) If there is NO DURATION, ie ZERO Days or ZERO Hours or ZERO Minutes or ZERO Seconds, then you CANNOT divide by ZERO.
[tt]
=If(Duration=0,0,Calls/Duration)
[/tt]


Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[gizmo1973]

Guess who forget to refresh!!!!
lol
Nice one G

Regards, Phil.

Full Member of Shareholders United.
Show your true support here:

http://www.shareholdersunited.org/join.php

"M.U.F.C. Not for sale to Glazier"

 

[xlbo]

s'ok - you beat Skip !!

I'm going home now so you can have the Americans to yourself !

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

Hey, Geoff. Stop off for a pint!

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[gizmo1973]

He had too many on Saturday
lol

Regards, Phil.

Full Member of Shareholders United.
Show your true support here:

http://www.shareholdersunited.org/join.php

"M.U.F.C. Not for sale to Glazier"

 

[xlbo]

Skip - pint sounds like a fantastic idea
<Homer>
mmmmmmmmm......beer
</Homer>

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

Here, it would be a Silver Bullet!

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}