| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating time
Hi, using Excel 2002 here.
I have 2 cells which are each formatted as "mm/dd/yy hh:mm" . I am trying to get the number of hours:minutes between them. Please note that there can be several days in between. How can I do this? Thank you in advance Gary |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating time
Subtract one from the other, and format as [h]:mm
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Gary H" wrote in message ... Hi, using Excel 2002 here. I have 2 cells which are each formatted as "mm/dd/yy hh:mm" . I am trying to get the number of hours:minutes between them. Please note that there can be several days in between. How can I do this? Thank you in advance Gary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating time | Excel Discussion (Misc queries) | |||
| calculating time | New Users to Excel | |||
| help with calculating overtime in a time sheet | Excel Discussion (Misc queries) | |||
| Calculating a rate for elapsed time? | Excel Discussion (Misc queries) | |||
| calculating with a time format cell | Excel Worksheet Functions | |||
Linear Mode
