This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Convert Duration to decimal

Posted on 06-03-2020 01:34 PM
Daisy_Ramirez
Silver 5
Silver 5
Reply posted on --/--/---- --:-- AM

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

2X_3_31e6ac4fed0bc1099b8c6d3e3f2a7c9dfd331e15.png

0 2 1,991
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
Reply posted on --/--/---- --:-- AM


Posted on --/--/---- --:-- AM
Daisy_Ramirez
Silver 5
Silver 5
In response to Steve
Reply posted on --/--/---- --:-- AM

Thanks so much Steve - completely over thought that one

Top Labels in this Space