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!
Views
Replies
Total Likes
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
Views
Replies
Total Likes