| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Calculating number of hours between two days
I wish to calculate the number of hours between two points in time.
For instance if I subtract 21-10-2005 12:10:00 from 22-10-2005 14:10:00 Excel should give 26:00:00 as the result. Can anyone answer? |
|
#2
|
|||
|
|||
|
Calculating number of hours between two days
Just subtract one from the other and format as [h]:mm:ss if you want it as
time, if you want bit as decimal use =(A21-A20)*24 and format as General -- HTH RP (remove nothere from the email address if mailing direct) "NMM" wrote in message ... I wish to calculate the number of hours between two points in time. For instance if I subtract 21-10-2005 12:10:00 from 22-10-2005 14:10:00 Excel should give 26:00:00 as the result. Can anyone answer? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of Days in a Date Range | Excel Discussion (Misc queries) | |||
| Text number to number value for calculating | Excel Worksheet Functions | |||
| Calculating interest on number of days in the period | Excel Worksheet Functions | |||
| Calculating Production/Man Days in Excel | Excel Discussion (Misc queries) | |||
| Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
Hybrid Mode
