LinkBack URL
About LinkBacks
for the sample provided:
where 12*(A1>B1) if the out time is less than the end time, then A1>B1 returns TRUE OR "1" else "0"
=IF(B1+(12*(A1>B1))-A1>6,B1+(12*(A1>B1))-A1-0.5,B1+(12*(A1>B1))-A1)
for the sample provided:
where 12*(A1>B1) if the out time is less than the end time, then A1>B1 returns TRUE OR "1" else "0"=IF(B1+(12*(A1>B1))-A1>6,B1+(12*(A1>B1))-A1-0.5,B1+(12*(A1>B1))-A1)
Last edited by protonLeah; 04-29-2010 at 10:55 PM. Reason: dropped a bracket
Ben Van Johnson
[QUOTE=protonLeah;2297008]for the sample provided:
CODE]=IF(B1+(12*(A1>B1))-A1>6,B1+(12*(A1>B1))-A1-0.5,B1+(12*(A1>B1))-A1)[/CODE]
where 12*(A1>B1) if the out time is less than the end time, then A1>B1 returns TRUE OR "1" else "0"[/QUOTE
This one worked great until there was a 12 hour shift I tried the >= but it did not work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks