danpino
asked on
Convert 0,90 into 1 hour 30 min in MS ACCESS
Hi, I need to convert 0,90 into 1 hour 30 min or
1,90 to 2 hour 30 min.
1,90 to 2 hour 30 min.
If your values are decimals, a one-liner will do:
datHours = TimeSerial(Int(t), (t - Int(t)) * 100, 0)
/gustav
datHours = TimeSerial(Int(t), (t - Int(t)) * 100, 0)
/gustav
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I still believe 0,90 and 1,90 represent decimal numbers, thus should be treated as so.
/gustav
/gustav
cactus_data,
Yes, that's interesting. But if the asker has continental settings so that 1,90 is the same as decimal 1.9 hours, then it would convert to 1 hour and 54 minutes, which is not what the asker expects.
Yes, that's interesting. But if the asker has continental settings so that 1,90 is the same as decimal 1.9 hours, then it would convert to 1 hour and 54 minutes, which is not what the asker expects.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Open in new window