Hi,

For purposes of a timesheet and overtime I have a cell that will reference 8hrs as a standard day using forumla =time(8,0,0) and cell formated custom [h]mm. I am now needing another cell to show 80hrs in a cell, but =time(80,0,0) doesn't work for me.

Is there something I am missing ? when I do =time(80,0,0) and using same custom format it onlys as 8:00 just like the 8hrs.

Im stumped