Excel 2007 - Multiply Hours by £ and end up with £'s

[dsmith910]

Hi
Just doing a timesheet/invoice for a client - managed to get a total of 52:20 hours for the week - but now need to be able to multiply it by, say, £30/hour. Obviously I need something more than =A5*B6 as this definitely gives me the wrong answer!
Can anyone help?

 

[TonyJollans]

It depends on the underlying data but if your hours are formatted time, the underlying number will be in days so you will have to multiply by 24 to get hours, thus, perhaps, [blue][tt]=A5*B6*24[/tt][/blue]

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[SkipVought]

FYI, faq68-5827

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[dsmith910]

Hi Tony underlying formats are [h]:mm - for time cells - this means I can have a total above 24 without ending up in days.

 

[mintjulep]

this means I can have a total above 24 without ending up in days.

No.

Excel's unit of time is the DAY.

Formatting a time value as [h]:mm changes the appearance, but it does not change the value.

 

[AnotherHiggins]

So did you try Tony's suggestion of multiplying by 24?


[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[dsmith910]

Hi Guys
Yes! just had chance (finally) to try multiplying by 24 and it works just great! Can't thank you enough!