How to multiply number of hours by number?

[Jon]

Hi,

How to multiply number of hours by a number? For example , if I have a total
number of 165 and 45 min(165:45) and I need to multiply by 34. How to do that
and how to input 165:45 in a table?

Thanks

 

[narasimhapuli]

Just take time as 165.45 and 34.
for Example ( If a man works 165 hours and 45 min. for Each hour he get Rs.
34.00 then just take 165.45 * 34 )

If he is getting every second then convert all the hours into seconds...
and calculate...

 

[Tom van Stiphout]

On Sat, 21 Mar 2009 03:06:11 -0700, Jon

Turn it into a floating point value, and store it in a Single field.
mySingle = Hours + Min/60

-Tom.
Microsoft Access MVP

 

[Jon]

hi Tom

but the result is 165.75 not 165.45!! please advice?

 

[John Spencer]

You want to store a duration of time. If you want to do this in one
field you are going to have to decide on the units you want to store.
Pick one: Hours, Minutes, or Seconds.

165 hours and 45 minutes is 165.75 hours.
Or you could store the total number of minutes.
165 hours and 45 minutes is 9945 minutes


If you store just hours you will need to store fractional parts of an hour.
Calculation will be
WorkHours * 34

If you store just minutes (total minutes) the calculation will be
WorkMinutes * 34 / 60

Another option is to use two fields - one to store hours and one to
store minutes (Partial hours).
If you use two fields the calculation would be
(WorkHours + WorkMinutes/60) * 34

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[fredg]

hi Tom

but the result is 165.75 not 165.45!! please advice?

That sounds correct to me. 45 minutes is 3/4 of an hour (.75).

 

[Tom van Stiphout]

On Sat, 21 Mar 2009 04:14:02 -0700, Jon

From the fractional hours you can go back to hh:mm in several ways,
for example:
dim h as integer
dim m as integer
dim mySingle as Single
mySingle = 165.75
h = int(mySingle)
m = (mySingle-h)*60
debug.print h & ":" & format(m,"00")

-Tom.
Microsoft Access MVP