Hi all,
I have a formula field I'm using to find the difference between two times (End_Time__c-Start_Time__c). With the formula written as is, it returns a number as part of 24 hours so if the total time was 12 hours, it displays as .5. How do I get this to show as HH:MM? I tried editing the formula and was able to get it in HH format (End_Time__c-Start_Time__c*24), but that still doesn't give me the minutes as I'd like them displayed.
Any help is greatly appreciated!
Unfortunately the Time Formula "rolls over" to PM once you hit 12 hours (I have not been able to figure out a way around that).
But the Text HH:MM does work all the way out to 24 Hours, but the downside of that one is that your data is just a Text string, not an actual HH:MM value
