MrExcel Publishing
Your One Stop for Excel Tips & Solutions

TimeSheet How to calculate time between 2 times - 30 min (lunch)


Posted by Pascal Fefer on November 06, 2001 7:21 AM

For my TimeSheet I'd like to calculate time between my arrival and my departure - 30 min (lunch)and to put it as decimal time (I have to work 7:36 per day, the rest is overtime).

Thanks
Pascal


Posted by Bob Umlas on November 06, 2001 7:47 AM

use =24*(A2-A1)-0.5 but then format the cell as general

Posted by Pascal Fefer on November 07, 2001 2:48 AM


Not Really pretty !!