| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time difference
This is time worksheet:
Time in/time out/Number hours/difference. First three are fine. The difference should be the difference between column C and 8 hours. Ideally, it would show the difference in hours and minutes. I've tried =C2-8, but all I get is #######. Any suggestions? -- Steph |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating time difference over midnight! | Excel Discussion (Misc queries) | |||
| How can I use a time difference in a subsequent formula in Excel? | Excel Worksheet Functions | |||
| Time Difference | Excel Worksheet Functions | |||
| What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
| Time / Formula to look at time difference | Excel Worksheet Functions | |||
Threaded Mode
