| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Is military time available in Excel? If so, how would I calculat.
if military time is available in Excel, how would I calculate sum?
|
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
| in excel totaling weekly hours military time | Excel Worksheet Functions | |||
| Excel 2003 - long closing time when have many add-ins installed | Excel Discussion (Misc queries) | |||
| How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
Linear Mode
