| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Quote:
Forget the date format, Excel dates are sequential numbers Your result will be 2.32638888889051 What does this mean? You have 2 days and 0.32638888889051 time Assign a 37:30:55 time format to 0.32638888889051 and convert this decimal date code to 7:50:00 You have 2 days and 7:50:00 hours Done Last edited by John_Franco : May 4th 09 at 06:51 PM Reason: Forget detailes |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set my time and get rid of sample time using functions | Excel Worksheet Functions | |||
| Calculating time without using time functions... | Excel Worksheet Functions | |||
| Time between days | Excel Worksheet Functions | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| date functions for previous 60/90/180 days | Excel Worksheet Functions | |||
Threaded Mode
