# Time Calculation

This is a discussion on Time Calculation within the Excel Questions forums, part of the Question Forums category; Hello, I want to end up with a decimal number for inbetween two times. I need a formula if its ...

1. 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.

2. 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?

3. Hi Sondriven

You might find this link helpful

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

Details how Excel sees Dates and Times

4. Thank you!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•