Expand my Community achievements bar.

How do I display a time difference as hours and minutes vs. a decimal?

Avatar

Level 1

Here's what I'm working with:

 

Total1

=(((Time2Num(Arrive1.formattedValue, "h:MM A")-Time2Num(Start1.formattedValue,"h:MM A"))+(Time2Num(Arrive2.formattedValue, "h:MM A")-Time2Num(Depart1.formattedValue,"h:MM A"))+(Time2Num(Home1.formattedValue, "h:MM A")-Time2Num(Depart2.formattedValue,"h:MM A")))/((1000*60)/

60))

However, the total is displayed as 1.5, and I need it to be 1:30, for example. Thanks!

1 Reply

Avatar

Level 10

Total1

=Num2Time((((Time2Num(Arrive1.formattedValue, "h:MM A")-Time2Num(Start1.formattedValue,"h:MM A"))+(Time2Num(Arrive2.formattedValue, "h:MM A")-Time2Num(Depart1.formattedValue,"h:MM A"))+(Time2Num(Home1.formattedValue, "h:MM A")-Time2Num(Depart2.formattedValue,"h:MM A")))/((1000*60)/

60)), "h:MM A")

you forgot to convert your decimal to time