Wolfin2010
New Member
- Joined
- Feb 21, 2015
- Messages
- 23
- Office Version
- 365
- Platform
- Windows
What I'm trying to do is, if total hours are less than 4 hrs give me the answer 4:00 otherwise subtract D-C
problem I'm getting is if the hrs are less than 4, I get exact answer not 4:00
I get answer 4:00 regardless the answer.
Any suggestions?
=IF(OR(INDIRECT("D"&ROW())="",INDIRECT("C"&ROW())=""),"",IF((INDIRECT("D"&ROW())-INDIRECT("C"&ROW())*24)>"4","4:00",TIME(HOUR(INDIRECT("D"&ROW())),MROUND(MINUTE(INDIRECT("D"&ROW())),15),0)-TIME(HOUR(INDIRECT("C"&ROW())),MROUND(INDIRECT("C"&ROW()),15),0)))
problem I'm getting is if the hrs are less than 4, I get exact answer not 4:00
=IF(OR(INDIRECT("D"&ROW())="",INDIRECT("C"&ROW())=""),"",IF((INDIRECT("D"&ROW())-INDIRECT("C"&ROW())*24)<"4","4:00",TIME(HOUR(INDIRECT("D"&ROW())),MROUND(MINUTE(INDIRECT("D"&ROW())),15),0)-TIME(HOUR(INDIRECT("C"&ROW())),MROUND(INDIRECT("C"&ROW()),15),0)))
I get answer 4:00 regardless the answer.
Any suggestions?