ExcelBanter

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

Don

Excel formatting
 
Hi,

I have an excel w/s which contains two columns - 'Duration' formatted as
hh:mm:ss and 'Cost' formatted as number x.xx. Is there an effective way to
establish a cost per minute?

Would appreciate assistance,

Don-

Gary''s Student

Excel formatting
 
if A1 and A2 contain:
$20.34
1:34:23


then:

=A1/(A2*24*60)

--
Gary''s Student
gsnu200711



All times are GMT +1. The time now is 06:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com