Figuring military time for total hours

[David Nelms]

Helping someone out with a worksheet that figures time (in military
time) for use at weekend race tracks. Generally they have two days so it
was easy with 2 IN's/2 OUT's for each day. But the rain at Daytona this
weekend created a problem we did not expect.

Someone starts work at Sat 0630 and finishes at 0130 Sun. Morning.

Excel is not giving the total in correct hours, but I realize that's
it's because you've gone to another day. As a workaround I told them for
now to enter it as 2 days 0630 to 2400 and 0000 to 0130....is there a
more elegant (or right) way to accomplish this?

David

 

[Barb Reinhardt]

Entering the start/stop time as date and time should resolve your problem.

 

[Peo Sjoblom]

1. Excel can't gibe the time correctly since 0630 or 0130 are time formats,
to excel they are the numbers 630 and 130, you have to use formulas to make
excel calculate as time

http://tinyurl.com/78bwz

where that example start time is in A1 and end time in B1

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Peo Sjoblom]

I meant they are not time formats and gibe should be give, doh!

--
Regards,

Peo Sjoblom

(No private emails please)