# Formula tp ca;culate hours worked using military hours and standard minutes

1. ## Formula tp ca;culate hours worked using military hours and standard minutes

I am looking for a formula to calculate totals time worked for the day using military hours and standard minutes.
For example "In" at 8:00 "Out" at 11:30 "In" at 12:00 "Out" at 4:30. The formula I am using does not convert the minutes.
Here is the formula I am using:

=((D11-C11)+(F11-E11))/100

2. ## Re: Formula tp ca;culate hours worked using military hours and standard minutes

I don't see what the /100 is for?

It should just be a straight addition of the 2 seperate time differences.
=(D11-C11)+(F11-E11)

3. ## Re: Formula tp ca;culate hours worked using military hours and standard minutes

The 100 is to convert in to total hours worked for the day in standard format.
Using the formula I currently am using returns a total hours for the day as 7.6 when it should be 8

4. ## Re: Formula tp ca;culate hours worked using military hours and standard minutes

I still don't understand how deviding by 100 converts a value to a time or vice versa.
what are the actual values in C11:F11 ?
Are they just numbers like 8 11.5 12 16.5 ?

Can you post a sample book?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1