I'm building a time card calculator to compute number of hours worked per day Clock In/Clock Out...need HELP rewriting the following formula...
=MROUND(IF((OR(B13="",D13="")),0,IF((D13<B13),((D13-B13)*24)+24,(D13-B13)*24)-C13/60),1/60)
I need this formula to calculate exact time/hours and not round to the nearest minute!
help!!!
=MROUND(IF((OR(B13="",D13="")),0,IF((D13<B13),((D13-B13)*24)+24,(D13-B13)*24)-C13/60),1/60)
I need this formula to calculate exact time/hours and not round to the nearest minute!
help!!!