Another Military Time conundrum

		Microsoft Office Forums > Microsoft Excel > Excel
Another Military Time conundrum

07-28-2022, 05:12 AM

Logit

Windows 10 Another Military Time conundrum

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

Code:

=MOD(C2-B2,1)

Example :

On duty ... 20:00 hrs; Off duty ... 01:00. Paste formula in D2, copy down column.

Attached Files

Tags

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:25 AM.