convert labour value in to time

A

alecgreen

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
 
M

Michel Walsh

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top