What I'm trying to do is calculate for overtime.
Cells D12 and c12 contain times.
C12 = 8:00 AM
D12 = 5:45 PM
Works as expected. Returns 0.75=(MINUTE(D12-C12) / 60)
Works almost as expected. Returns 8.45=IF(NOT(D12 = ""),IF(D12-C12=0,"",(HOUR(D12-C12) & "." & MINUTE(D12 - C12) )- 1),"")
Fails with #VALUE=IF(NOT(D12 = ""),IF(D12-C12=0,"",(HOUR(D12-C12) & "." & (MINUTE(D12 - C12)/60) )- 1),"")
What am I doing wrong?
Bookmarks