If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
negative time summation calculation for a standard day
I am trying to use calculations with time in the form hh:mm - hh:mm and EXCEL
does not like negative time. The calculation is to accumulat over a week the actual time worked by aggregating the hours worked on a daily basis. Thus at the end of the week the time worked is ((monday time worked) XX:XX - 7:12 + (tuesday time worked) XX:XX - 7:12, etc for the week) |
#2
|
|||
|
|||
negative time summation calculation for a standard day
Tool Options Calculation check 1904 date system
or convert excel time to decimal by multiply by 24 "Glamb" wrote: I am trying to use calculations with time in the form hh:mm - hh:mm and EXCEL does not like negative time. The calculation is to accumulat over a week the actual time worked by aggregating the hours worked on a daily basis. Thus at the end of the week the time worked is ((monday time worked) XX:XX - 7:12 + (tuesday time worked) XX:XX - 7:12, etc for the week) |
#3
|
|||
|
|||
negative time summation calculation for a standard day
Excel will happily do any calculations with times, it just won't *display* a
negative time. If you don't ever have to display a negative time, then just do the calculations. If you do, TM has given you the options. Regards, Fred "Glamb" wrote in message ... I am trying to use calculations with time in the form hh:mm - hh:mm and EXCEL does not like negative time. The calculation is to accumulat over a week the actual time worked by aggregating the hours worked on a daily basis. Thus at the end of the week the time worked is ((monday time worked) XX:XX - 7:12 + (tuesday time worked) XX:XX - 7:12, etc for the week) |
Thread Tools | |
Display Modes | |
|
|