Hours tracking in schedule.
I need some help troubleshooting a formula. I have viewed the numerous posts on time tracking in smartsheet and have used the formulas in this post: https://community.smartsheet.com/discussion/67111/calculating-military-time-from-am-pm-format.
My problem is the when any time past midnight is still showing up as "PM" instead of switching to "AM".
Any help would be greatly appreciated. Thanks!
In the above picture, you can see at the last row, the 5hr duration should make the end time 1:30am instead of pm.
End Column Formula:
End Time Column Formula:
Help Article Resources
Check out the Formula Handbook template!