I need a formula that will change 5:27 5 hours and 27 minutes into 5.45 hours.,..?
any suggestions
extract minutes from timestamp as an integer value
percentage = minutes / 60
round percentage to 2 digits
place hour and rounded percentage into proper format for final result