So being a total Excel novice I'm reaching out to the Empeggbbs brain trust for some help. I have what I think is a trivial problem that I'm hoping someone here can help with.

I trying to create a shift schedule for work and I want to calculate the total hours worked for the week. Here is what I have, as an example:



That is start time and end time in 24HR format.

The formula for the weekly total is:



However if I have 00:00 as a shift end it's giving me a error, or more exactly a incorrect total of -100.00

Any suggestions? Apologies for the bad formatting above, not sure how to clean that up.

You need to denote midnight shift ends as 24:00 rather than 00:00. (And 1am / 2am etc finishes as 25:00 / 26:00 and so on).

That's it! Thank you!!

Bringing up a thread from the past. I'm again working on the same project and I've gotten in over my head, again!

I'm really going way past what I need for this project, but if I'm going in on this I might as well go for broke and try and learn something along the way.

I'm trying to get this to calculate not only the hours per shift, and per week, which I've already managed, but to also calculate how many people are working any given shift. I'd like to make this 'future proof' or at least as close as I can to that.

Here's what I've got so far. Here's a link to the file in question, hosted on my OneDrive.

Execl file found here

Any suggestions?