Time Calculation

[sondriven]

Hello,

I want to end up with a decimal number for inbetween two times. I need a formula if its possible for this:

B4 = Start Time
C4 = End Time
D4 = =TEXT(C4-B4,"h:mm") For the calculation

Then I get the amount in time value. This is good but I need a formula that will take this time and divide by 60 so I can get the time in decimal form.

Thanks.

 

[Aladin Akyurek]

On 2002-07-22 12:06, sondriven wrote:
Hello,

I want to end up with a decimal number for inbetween two times. I need a formula if its possible for this:

B4 = Start Time
C4 = End Time
D4 = =TEXT(C4-B4,"h:mm") For the calculation

Then I get the amount in time value. This is good but I need a formula that will take this time and divide by 60 so I can get the time in decimal form.

Thanks.

Why not just use in D4:

=(C4-B4)*24

which you format as General?

 

[Dave Hawley]

Hi Sondriven

You might find this link helpful

http://www.ozgrid.com/Excel/ExcelDateandTimes.htm


Details how Excel sees Dates and Times

 

[sondriven]

Thank you!