Check the link below to see whether it helps. Regards.

http://www.cpearson.com/excel/overtime.htm

"Les" wrote:

I am trying to calculate a table with a 24hr runing clock so i can tell if
someone works over 12hr in a 24hr period. I need to have a 24hr clock runing
so i can tell how much they have worked in the past 24hr based on the present
time, throught out the day.