If time is shown in A1 in Excel format 6:00 for 6 elapsed hours:
If currency amount is in B1
C1:
=(A1*24)*B1
Format currency
Time is stored by Excel as a decimal of 1 day so we need to convert to
hours before multiplying by the currency.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
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.
