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.
