| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES
Start date and time is 9/12/05 06:35, finish date and time is 9/13/05 13:45.
TOTAL hours are 31 hrs 10 min. I tried different forulas and would only get 7 hrs 10 mins. excel kept leaving off the 24 hours. Is there someway I can get excel to add the total hours without leaving off the 24. |
|
#2
|
|||
|
|||
|
Format the result cell as [h]:mm
-- Ian -- "tankerman" wrote in message ... Start date and time is 9/12/05 06:35, finish date and time is 9/13/05 13:45. TOTAL hours are 31 hrs 10 min. I tried different forulas and would only get 7 hrs 10 mins. excel kept leaving off the 24 hours. Is there someway I can get excel to add the total hours without leaving off the 24. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time functions, how do I work out number of hours | Excel Worksheet Functions | |||
| How to get difference in hours | Excel Worksheet Functions | |||
| How to calculate time between two dates? | Setting up and Configuration of Excel | |||
| Sumproduct help needed! | Excel Worksheet Functions | |||
| What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
Linear Mode
