Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to calulate time in hours cbetween two different dates?
I use Excel 2003. I cannot find out time in hours between two different
dates, for example - time in hours between 2300 hrs/ 23.10.05 and 0800 hrs/26.10.05. Can anyone advise? |
#2
|
|||
|
|||
how to calulate time in hours cbetween two different dates?
If the date/time is a true date value, try...
A1: 10/23/05 23:00 B1: 10/26/05 8:00 =B1-A1 ....and custom format your cell as [h]. Hope this helps! In article , "shonkoo" wrote: I use Excel 2003. I cannot find out time in hours between two different dates, for example - time in hours between 2300 hrs/ 23.10.05 and 0800 hrs/26.10.05. Can anyone advise? |
#3
|
|||
|
|||
how to calulate time in hours cbetween two different dates?
For result cell use custom number format "[h]", if you want to be display
minutes also then "[h]:00, and if you want to have fraction of hours, use general format, and divide result with 24. "shonkoo" wrote in message ... I use Excel 2003. I cannot find out time in hours between two different dates, for example - time in hours between 2300 hrs/ 23.10.05 and 0800 hrs/26.10.05. Can anyone advise? |
#4
|
|||
|
|||
how to calulate time in hours cbetween two different dates?
Correction:
Not divide, but multiply with 24, to get fraction of hours... "Mladen_Dj" wrote in message ... For result cell use custom number format "[h]", if you want to be display minutes also then "[h]:00, and if you want to have fraction of hours, use general format, and divide result with 24. --------------------------- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate difference in time spanning a day, during office hours o | Excel Discussion (Misc queries) | |||
using time functions when hours are greater than 10000 | Excel Worksheet Functions | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
Is there a time sheet template that calculates hours? | Excel Discussion (Misc queries) | |||
Stumper WORKDAYS Problem | Excel Discussion (Misc queries) |