Expert: Sherry Wallin - 8/29/2010

Question
Hello and thank you in advance for being available for my question. My business uses Military time for payroll. On occasion, staff will forget to clock out and I will have to adjust their time. I am very confused about adding and subtracting military time.I have searched the Internet and have had no luck understanding. Is there a simple solution or is there a calculator that I can buy specifically for military time or a spreadsheet in Excel? Thanks again

Answer
Anna~

I answered this question but it must have gone to La La land. So here we go again:

If the sign in time is a smaller number than the sign out time just subtract the beginning time from the ending time. Ex: signed in at 0600 and signed out at 1530, the 1530 - 0600 = 0930 -> 9.5 hours

On the other hand if their sign in time is a bigger number than the time they signed out then take the sign in time away from 2400 and then add the sign out time. Ex: they started at 2200 and signed out at 0600, then 2400- 2200 = 0200 and then add 0600 to 0200 for 0800 (8)hours.

Math Prof

Suppose they worked a very long shift and started at 0600 and they were still working the next day until 0100. Now you need to take 2400 - 0600 = 1800 and add 0100 for a total of 1900 = 19 hr