| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cumulative time in excel
Got it working.
Thanks "Peo Sjoblom" wrote: If you want to use time format you can either change to 1904 system under toolsoptionscalculation however it will change dates in your system by adding 1462 days to any date or you could use something like =IF(A1B1,ABS(B1-A1),B1-A1) copy down then to sum use =SUMPRODUCT(--(B1:B30A1:A30),C1:C30)-SUMPRODUCT(--(A1:A30B1:B30),C1:C30) will fail if the total is negative you can also convert the time values to decimals and use them then convert back to time but that won't help you if the total is negative -- Regards, Peo Sjoblom "Lerxst" wrote in message ... I am trying to get a function that will add time in the format of hours:minutes. Each cell is the difference between actual time and forecast time. Therefore sometimes I have a negative value. I cannot add the values if I have a negative time cell. example: C1 is the difference between A1 and B1, lets say it equals :40 (40 minutes) C2 is the difference between A2 and B2, lets say it equals :37 (37 minutes C3 is the difference between A3 and B3, lets say it equals -:07 (7 minutes under forecast) The totals for column C should equal 1:10 (1 hour 10 minutes) but it doesn't allow a negative time value. Any ideas how I can make this work and how I should format the cells???? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| Insert spinning button with time format in Excel 2000? | Excel Discussion (Misc queries) | |||
| export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Excel Date Time to Unix Time | Excel Discussion (Misc queries) | |||
Hybrid Mode
