Hours and minutes question

  • Thread starter Thread starter Mike McKenzie
  • Start date Start date
M

Mike McKenzie

Hello

I know how to display values as hours and minutes (you use
the colon) Excel can add values displayed in this way (eg
1:30 + 1:30 = 3:00) - but I need to multiply an
hours/minutes value by a general number -

Let's say I worked One and a half hours at £10 per hour

I want excel to give me...
1:30 * £10.00 = £15.00

Any suggestions
 
Hi Mike!

With a total time in A1
=A1*24*10
Format General or currency.

Just remember that Excel treats time as a decimal part of one day.
Hence the need to multiply by 24 to get raw hours
 
=time_worked*24*10

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


Hello

I know how to display values as hours and minutes (you use
the colon) Excel can add values displayed in this way (eg
1:30 + 1:30 = 3:00) - but I need to multiply an
hours/minutes value by a general number -

Let's say I worked One and a half hours at £10 per hour

I want excel to give me...
1:30 * £10.00 = £15.00

Any suggestions
 
Hi Mike,

Times are stored as a fraction of a day, so although 1:30 is displayed in
hours it is stored as (1.5/24) 0.0625 of a day. Multiply the hours by 24
before making your calculation, and you'll get the answer you need:

=1:30 * 24 * £10.00



Hello

I know how to display values as hours and minutes (you use
the colon) Excel can add values displayed in this way (eg
1:30 + 1:30 = 3:00) - but I need to multiply an
hours/minutes value by a general number -

Let's say I worked One and a half hours at £10 per hour

I want excel to give me...
1:30 * £10.00 = £15.00

Any suggestions
 
Back
Top