Calculating hours worked with Military time

[Tonia_Dykes]

I am currently working on a scheduled hours report. I have gone through many of the military conversion options via the community however I am still struggling. Looking for some assistance on how to convert the below 14:00-00:00 into hours scheduled to work. All of these are exceptions that I cannot seem to get right. I am not sure what I am doing wrong.

I have attached the report I am working with. I have to take each days shift and create a column of hours to be worked. As I stated all the time conversions seem to be working but every week I get more exceptions like the ones listed above. I am aware that some schedules may be entered wrong but regardless my final solution is to come up with hours-minutes scheduled for each shift/day.

[Christina_H · Accepted solution]

Do you want hours for each day, or a total for the week?  This includes both.

[Tonia_Dykes]

Awesome - I was just off on my formula! Thanks so much!