|
|
#6
07-28-2022, 11:22 AM
|
|||
|
|||
You should include the day/date portion of the values when calculating elapsed time.
As far as "Military Time" that is just a formatting thing that has noting to due with the calculation. Most people seem to want to enter the Time separate from the date. You can enter the the current Date and Time using the keystrokes: CTRL+: CTRL+; and then edit if you're entering from a separate record. 
|
| Tags |
| boogered up, military time |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I plot data points on time axis proportionally to time scale? | gib65 | Excel | 4 | 04-05-2022 10:24 PM |
| Obtaining a decimal total hours from military time entries (my solution works only in Google Sheets) | gluonman | Excel | 8 | 03-22-2017 08:26 PM |
 Employee Turnover by Department/Month split between Voluntary/Involuntary - Full-time/Part-time
|
CPSmith | Excel | 1 | 03-26-2016 02:48 AM |
| Military Font in Word | jmdraft | Word | 2 | 03-06-2016 05:31 AM |
| IE Object: Run-time problem (the link is not clicked in run-time but not in step-in | tinfanide | Excel Programming | 1 | 03-04-2012 12:05 AM |
Windows 10 
Office 2021
Threaded Mode