comparing hours using if function

C

cheizm

I'm trying to design a spreadsheet that sums up total numbers worked fo
a week and then compares that total value to 40 to see if any overtim
hours were worked. The problem is that since the times that I'
comparing are in HH:mm format, excel isn't recognizing when I try t
compare it to the value of 4
 
N

Norman Harker

Hi Cheizm!

Format your sum [hh]:mm:ss

Compare to 40/24

Or multiply your sum by 24 and compare to 40.

Note that time is handled by Excel as a decimal part of a day so you
compare to 40/24 or multiply by 24 before comparing.

See:
Chip Pearson:
http://www.cpearson.com/excel/overtime.htm
 
Top