Calculating Military Time from am/pm format
Trying to convert am/pm format to a military time format (i.e. 12:30 am would read 0030, 11:00 pm would read 2300, 8:15 pm would read 2015) from there I would be able to calculate a duration time by subtracting the start time from the end time.
I have scoured the existing solutions out on the community and none are working (hrs in one column, minutes in another, etc)
Any help would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!