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.
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.
