Forum Discussion
Solved
Help with calculating empty Time data in cells
I am attempting to create a Roster Spreadsheet to calculate hours workedin a week (the hours worked are calculated in a hidden field), The tempolate must cater for days off , i.e. no times entered, b...
Does this do what you want?
=IF(OR(H6="",I6=""),0,MROUND(MOD(I6-H6,1)-(MOD(I6-H6,1)>=7/24)*(I6>H6)*$F6/1440,1/1440))
Hello Hans,
Yes, I have tested with various times and it works perfectly, thank you very much for your halp again, Joe
Yes, I have tested with various times and it works perfectly, thank you very much for your halp again, Joe