Hello all! Looking for some quick formula help because I am terrible at them 
I have a TIME IN and a TIME OUT setup, with a third column to calculate DURATION (OUT - IN)
Nice and simple. However on rare occasions the OUT time is past midnight, therefore smaller than the IN. Which then doesn’t calculate correctly. Based on other posts the first answer to the problem is to change my input fields to add dates, which I don’t want to do.
So my solution is a quick checkbox field to indicate a Next Day rollover (which actually helps me in another report). I then need the DURATION to calculate a +12 hours if checked.
So something like OUT (+ 12:00 if [Next Day]=checked) - IN
But all my attempts aren’t quite right. Any ideas from my magical community? Thanks!!! 
You do not need a checkbox. If out time is smaller than in time, you an in the formula consider the out being next day and you can calculate the difference between the out time and midnight and add it to the difference between in time and midnight. One caveat is that you have to check that if the out time is smaller than 24 but bigger than the in time…. you calculate it as being within same day.
That makes perfect sense!! Hopefully someone can show me what that formula actually looks like 
I’ll share a demo in here later when I get my hands on my laptop.
this is one option:
1 represents 24hrs
cheers, christiaan
This works great, thank you! I just need to tweak it so it doesn’t display anything with no input (currently shows 24 hours for everyone with no hours yet lol)
I’m trying to add an additional instruction to the formula that if the OUT (end in Christiaans example) is blank the result needs to be zero (or even nothing)
Tried ifBlank but I can’t seen to make it work!
did you consider this option:
If(
thisRow.Start.IsNotBlank() and thisRow.End.IsNotBlank() and thisRow.End < thisRow.Start,
thisRow.End + 1 - thisRow.Start,
thisRow.Start - thisRow.End
)
May I kindly ask you for the next time to share a sample document? Thanks for understanding.
