Conditional IF to use or / and

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

keyinput - 18 Oct 2006 19:41 GMT

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?

Reply to this Message

Gary L Brown - 18 Oct 2006 19:57 GMT

=(+G4-F4)*24

HTH,

Signature

Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.

> I am working with a tracking form for hours worked.
> E12=11:00 AM
[quoted text clipped - 5 lines]
> 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?

Reply to this Message