Forum Discussion
Solved
Time Conversion to Hours
A particular data base exports hours data incorrectly as a 'clock' value. For example, 1.5 hours would be exported as 1.3 hours, 1.25 hours as 1.15 hours etc. No idea why...but the 'minutes' value is...
EVALUATE var Val = 1.45 // 1 hour, 45 minutes var Hours = int( Val ) var Minutes = ( Val - Hours ) * 100 var HourMinutesInDecimal = ( Hours * 60 + Minutes ) / 60 return { HourMinutesInDecimal } // output: 1.75
EVALUATE
var Val = 1.45 // 1 hour, 45 minutes
var Hours = int( Val )
var Minutes = ( Val - Hours ) * 100
var HourMinutesInDecimal = ( Hours * 60 + Minutes ) / 60
return
{ HourMinutesInDecimal } // output: 1.75Thanks for that, it really is a great solution. I got very close to thinking in that way also but you are so clear and efficeint compared to where i was at. Much appreciated!
