|
|
#8
02-21-2023, 11:04 PM
|
|||
|
|||
In case the date part is always left out, and calculated time interval will always be less then 24 hours, the formula like below will work
Code:
=(B2<A2) + B2-A2 
|
| Tags |
| boogered up, military time |
| Thread Tools | |
| Display Modes | |
|
|
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 8 
Office 2016
Threaded Mode