| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How Can I subtract from time within a 24 hour clock?
Hi,
I'm very new to excel and trying to make myself a template with a timeline based on an Event and various times before the event. I managed to achieve a working table but I have a problem as I work through midnight. i.e. If the event time is 01:00 and I need to take away 1:30, i want the table to display 23:30. at the moment it displays -0:30. I'm using the current formula and the columns are formatted to time. =D2-C3 Thanks for looking Oggy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add/sub time/hour tracking in 24 clock format | Excel Programming | |||
| How do I enter time (12-hour clock) & have it display it? | Excel Discussion (Misc queries) | |||
| counting cells within certain time frames - 24 hour clock | Excel Discussion (Misc queries) | |||
| 24 hour clock formula for elapsed time between 1215 and 1630 | Excel Worksheet Functions | |||
| time diffrence with 24 hour clock | Excel Worksheet Functions | |||
Threaded Mode
