Thread: Another Military Time conundrum
View Single Post
 
Old 07-28-2022, 05:12 AM
Logit Logit is offline Windows 10 Office 2007
Expert
  
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default
Code:
=MOD(C2-B2,1)
Example :


On duty ... 20:00 hrs; Off duty ... 01:00. Paste formula in D2, copy down column.
Attached Files
File Type: xlsx How Many Hours EvenPastMidnight.xlsx (9.9 KB, 6 views)
Reply With Quote