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)

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)

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)