Posted by Karen on December 29, 2000 8:33 AM
I am trying to set a formula that will calculate time on a timesheet. I have an in column and an out column. I want the cells to read the time as am/pm. For example, in cell b3 (in) I have 8:30am. In cell c3 (out) I have 8:00pm. How do I get the formula (in cell b4) to tell me how many hours were worked, in a simple format such as 11.5 as opposed to 11:30? Also, I would like for the cell (b4) to be blank if no hours were worked instead of printing (0). Can anyone help? I'm desperate.