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

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

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" wrote in message
...
if military time is available in Excel, how would I calculate sum?

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" wrote:

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" wrote in message
...
if military time is available in Excel, how would I calculate sum?

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)



"timp" wrote in message
...
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" wrote:

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" wrote in message
...
if military time is available in Excel, how would I calculate sum?