Time and currency

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

I have one cell formatted as a time [hh].mm and another cell formated as a
currency 000.00

Now what I want to do is to divide the total in my currency cell by the
total in my time cell, to work out how much on average something costs per
hour.

I would change my currency cell to a [hh]:mm cell so that it worked out ok,
however I am taking information from other protected worksheets which are
also formated as time and so cannot do anything!

Any advice (if my query makes sense?)

Basically, I want to work out divide a number within a currency cell divided
by a time cell!
 
Hi!

With time in A1 formatted as time and currency in B1 formatted as
currency

=B1(A1*24)
Format currency

Time is recorded as a decimal part of 1 day so you need to convert to
hours before dividing.
 
The formula should be:

=B1/(A1*24)

This is extremely unusual for Norman, because I don't remember his ever
making a mistake before. I probably won't live long enough to see another.
Keep up the good work, Norman. Your posts are excellent.
 
Perfect!

Thanks all! I knew it would be something obvious!

Thanks once again
 
Hi Fred!

Re: "I don't remember his ever making a mistake before"

Too many, I'm afraid. That's why I usually test even the simplest
formula and copy and paste to replies.
 
Back
Top