Military Time for Time Sheets ex:23:00/7:00 =8 hrs.

[Guest]

Hi, When filling in our time sheets using military time, the format of 23:00/7:00 (11 PM to 7 AM) will not total '8' hours?

 

[Peo Sjoblom]

=MOD("07:00"-"23:00",1)

or better put 07:00 in A1 and 23:00 in B1 then use

=MOD(B1-A1,1)

--

Regards,

Peo Sjoblom

Hi, When filling in our time sheets using military time, the format of

23:00/7:00 (11 PM to 7 AM) will not total '8' hours??

 

[Peo Sjoblom]

Sorry, meant 23:00 in A1 and 07:00 in B1

 

[Guest]

-----Original Message-----
Hi, When filling in our time sheets using military time,

the format of 23:00/7:00 (11 PM to 7 AM) will not
total '8' hours??

.
A B C

2300

 

[Guest]

-----Original Message-----
Hi, When filling in our time sheets using military time,

the format of 23:00/7:00 (11 PM to 7 AM) will not
total '8' hours??

A B C

1 2300 0700 =(2400-A1+B1)

It wouldn't hurt to format the sells as "custom", then
where it says "generall" type 0000 (four zeros). This
will make 7:00 truely military and appear as 0700.

 

[Peo Sjoblom]

Or if the OP wants to transfer it to real time from military



=MOD((INT(B1/100)+MOD(B1,100)/60)/24-(INT(A1/100)+MOD(A1,100)/60)/24,1)


where A1 holds 2300 and B1 700

 

[Peo Sjoblom]

Come to think of it, if you really want to type in the times as 23:00/7:00
and get the result
as 08:00 you can use this

=MOD(MID(A1,FIND("/",A1)+1,255)-LEFT(A1,FIND("/",A1)-1),1)

where A1 holds 23:00/7:00