Timecard formulas

  • Thread starter Thread starter josiecottn
  • Start date Start date
J

josiecottn

I am using the formula: if(a1>8,a1-8,"")

What I need to do is have excel calculate the regular hours (8) into
one column, and the overtime hours into another (ex: 2 hrs overtime
8+2=10). However, the above formula does not seem to recognize
military time. Any suggestions on how to acheive the same result??
 
Josie,

Is this what you want?

=IF(A1>8/24,A1-8/24,"")

Time is stored as a fraction of 1 day, hence the division by 24.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top