![]() |
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- |
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