Figuring military time for total hours

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

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

"David Nelms" <[email protected]> wrote in message
news:[email protected]...
> 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

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)


"David Nelms" <[email protected]> wrote in message
news:[email protected]...
> 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

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Peo Sjoblom" <[email protected]> wrote in message
news:[email protected]...
> 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)
>
>
> "David Nelms" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>