Is military time available in Excel? If so, how would I calculat.

[TimP]

if military time is available in Excel, how would I calculate sum?

 

[Peo Sjoblom]

What is military time? Like this? 600 1000 2400 etc?
If so


=MOD((INT(B1/100)+MOD(B1,100)/60)/24-(INT(A1/100)+MOD(A1,100)/60)/24,1)start
time in A1 and end time in B1
--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[timp]

basic spreadsheet as follows:
0800 start time, 1200pm end time, total time
These blocks of time represent jobs, and there will be 4 jobs on one sheet.
thanks.


how do I format the cells (i.e., by number, time, general)

 

[Peo Sjoblom]

You can use the formula I provided, replace B1 with your end time cell and
A1 with your start time cell
format as hh:mm to get time excel can understand

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)