Calculate total time per day
Posted by Karen on December 29, 2000 11:47 AM
Okay, the formula for the time works great, but now I need to calculate total hours/minutes per day and week and grand total. I have the formula to calculate the hours/minutes in cells (b4) and (b6). In cell (b7) I want the total of the two, with the cell being blank if there is nothing in cell (b4). I have tried IF, and SUM but I keep getting (#value). Any suggestions?
Posted by Aaron on December 29, 2000 12:02 PM
Make sure that all cells involved are TIME format.
=IF(B4=0,"",B4+B6) should work.
Posted by Karen on December 29, 2000 3:00 PM
If I make all cells involved TIME format, the other calculations won't work. I want the cells that have the time in them in time format, but the ones that I have formulas in I want in number format, because I want it to read 11.5, etc. instead of 11:30, etc. So, do you have any suggestions for this?
Posted by Dave on December 29, 2000 8:14 PM
Hi Karen
Try:
IF(B4="","",(B4+B6)/24)
and format the cell as [h]:mm:ss under Custom formats. Then it can display hours greater than 24.
Dave
- OzGrid Business Applications
