ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula (https://www.excelbanter.com/excel-discussion-misc-queries/41401-formula.html)

laksmi

Formula

I would like to know procedure for multipling a currency against a time format

Anne Troy

I think you'll have to provide an example. Perhaps $20 x 3:00 (3 hours,
where the formula bar shows 3 AM as the time), you can use: =A1*(B1*24)

************
Anne Troy
www.OfficeArticles.com

"laksmi" wrote in message
...
I would like to know procedure for multipling a currency against a time
format

All times are GMT +1. The time now is 03:55 PM.