| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I need 19:00 - 7:00 to display 12:00
My sheet shows tool down times for a works project
A1 = 19:00 (in time format) B1 = 7:00 (in time format) C1 = =B1-A1 which displays ############# How do i minus time after 00:00 0:00 If i take 19:00(B1) from 19:01(C1) it gives me the correct answer of 0:01, its just with numbers after 00:00. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to sort dates before 1900 in proper order | Excel Discussion (Misc queries) | |||
| Find & Replace results to display specified chosen fields | Excel Discussion (Misc queries) | |||
| Axis display as category | Charts and Charting in Excel | |||
| Help Q: Entering 7 p time format, does not convert to 19:00 | Excel Discussion (Misc queries) | |||
| Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
Threaded Mode
