Forum Discussion
Solved
Integrating MROUND in to time formula
Hello, I'm creating a basic timesheet that calculates hours.My goal is to have the total hours worked displayed in a cell, but also round it to the nearest :15 (MROUND) and I can't get the struct...
Correct, I copy/pasted your formula - it works
assuming you are on English locale. And in attached file
Thanks for the reply, but it generates an error when I try it. To ensure I'm not entering it incorrectly, it would be:
=MROUND(IF([@[Stop Time]]<[@[Start Time]],[@[Stop Time]]+1,[@[Stop Time]])-[@[Start Time]],"00:15")
Is that correct?
Correct, I copy/pasted your formula - it works
assuming you are on English locale. And in attached file
Thank you Sergei! I must've missed something. When I copied and pasted it in it worked this time. Thanks again.