View Single Post
Old 01-14-2010, 04:01 PM
cubsfan_1 cubsfan_1 is offline Windows XP Office 2003
Join Date: Jan 2010
Posts: 1
cubsfan_1 is on a distinguished road
Default Can I do calculations with times?

I am doing an employee check in sheet. I want to enter the time an employee finishes for the day, compare that time to quitting time and display the amount of overtime worked if any. =IF(cell>6:30,cell-6:30,0) is what I am trying to use. Time isn't a valid value though.
Reply With Quote