military time conversion hundredths


J

JD Fields

The problem is our time clocks are in military time(and
frequently go over midnight) so you can not just
subtract time in from time out.

time in - time out = total hours time in and time
out are entered in military time(from the time clock)
ex. 1500-2015=x x=5.25 rather than 5.15
.30 = .50 of an hour
.15 = .25 of an hour etc
I need the total to be in hundredths for accounting as we
then multiply it by the pay scale. Does this make sense -
can you help me please
 
Ad

Advertisements

J

JohnI in Brisbane

JDFields,

In your original message you had the times formatted as 15:00 & 20:15,
whereas in the last message you had 1500 & 2015.
The format makes a difference to the result. Which format will you be using?
The solutions provided were based on your original format.

Also, are you after the answer in the format - 515 or 5.15 or 5.25 ?

As you say below:- 15 minutes = 0:15 = 0.25 hours.

In your original request you asked for the answer to be in decimal hours,
so I thought you would be after 5.25 (i.e. 5 1/4 hours) or ( 5 hours 15
minutes = 5:15).
If you want hundredths of an hour then 5.25 is correct. Is that what you are
saying below?

regards,

JohnI
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Military Time 4
military time 9
Military Time 2
Military Time 1
Military time 6
Formatting Time with Hundredths of Seconds 1
Using military time 4
Military time trouble 7

Top