You can create computed column. In the query designer, type, in a new
column:
LaborValue / 10.97
to get the number of hours, and decimal of hours.
You can also try something like:
int(laborValue / 10.97) & ":" & Format(laboutValue / 10.97 / 24.0,
"nn" )
to get a STRING representation of hours:minutes, where hours amount can
exceed 24. Since that computed expression is a string, you won't be able to
do much computation with it, though. I divided by 24.0 because Access expect
date_time to be in days and decimal of day, not in hours and decimal or
hours.
Vanderghast, Access MVP
Hi
I have a labour value in pounds stirling, and my labour rate is £10.97
per hour - and want to convert this into hours and minutes. Any help
would be appreciated.
Alec