Convert Duration to decimal

Iโ€™m having trouble converting duration to a decimal. Can someone assist with the right expression? Iโ€™ve separated the hours from minutes and then attempted to divide the minutes by 60 in order to get the portion of hours but Iโ€™m getting the result further below.

HOUR([End Date Time]-[Date Time Entered])&"."&(MINUTE(TIME([End Date Time])-Time([Date Time Entered])))/60

0 2 2,883
2 REPLIES 2

Steve
Platinum 5
Platinum 5


Thanks so much Steve - completely over thought that one

Top Labels in this Space