Anyone know how to use multiple if statements in one cell? I'm trying to make a schedule for work using in and out times while also subtracting 30 mins if the shift is over 5 hours. I came up with this,IF(C5-B5<5/24,C5-B5,C5-B5-0.5/24)
ANSWERS: 1
Sort by: Highest Rated
-
If I read this right, than is your in time in B5 and your out time in C5. I should try something like IF((C5-B5)<(5/24),C5-B5,(C5-B5)-(0.5/24))
-
No comments
RELATED QUESTIONS
RELATED TOPICS
ABOUT ANSWERBAG
Answerbag wants to provide a service to people looking for answers and a good conversation. Ask away and we will do our best to answer or find someone who can.We try to vet our answers to get you the most acurate answers.
Copyright 2023, Wired Ivy, LLC