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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
=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

Frank & Maryanne said:
Hi, When filling in our time sheets using military time, the format of
Click to expand...
23:00/7:00 (11 PM to 7 AM) will not total '8' hours??
 
-----Original Message-----
Hi, When filling in our time sheets using military time,
Click to expand...
the format of 23:00/7:00 (11 PM to 7 AM) will not
total '8' hours??
A B C
Click to expand...
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.
 
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
 
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
 
Back
Top