I am working with a tracking form for hours worked.
E12=11:00 AM
E13=11:30 AM etc
F12=12:00 PM

F4=EMPLOYEE start shift time
G4=employee end shift time
F4 can start at 11 or 11:30 how do I write an if statement to result in 1
for every hour they work but not past the hour their shift ends?

=(+G4-F4)*24

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"keyinput" wrote:

I am working with a tracking form for hours worked.
E12=11:00 AM
E13=11:30 AM etc
F12=12:00 PM

F4=EMPLOYEE start shift time
G4=employee end shift time
F4 can start at 11 or 11:30 how do I write an if statement to result in 1
for every hour they work but not past the hour their shift ends?