negative time summation calculation for a standard day

G

Glamb

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)
 
T

Teethless mama

Tool > Options > Calculation > check 1904 date system
or
convert excel time to decimal by multiply by 24
 
F

Fred Smith

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with a formula for a Time Sheet. 1
How do I limit formula results to positive only? 4
Add Time Q 4
Time Zone Conversion Table 1
Check if Time falls between ? 3
Level resource allocation error 1
adding up time over & under a specified amount 3
Calc staff vacation time based on more than 1 criteria 0

Top