ExcelBanter - 90 min

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - 90 min - 1:30 (https://www.excelbanter.com/excel-programming/276736-90-min-1-30-a.html)

Mario[_5_]

90 min - 1:30

hi,
i have a small problem
how can i transvere 90 min into 1:30

tks mario

Ron de Bruin

90 min - 1:30

Try this

=A1/1440

with in cell A1 90
format the cell as time

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl

"Mario" wrote in message y.telekom.at...
hi,
i have a small problem
how can i transvere 90 min into 1:30

tks mario

All times are GMT +1. The time now is 08:07 PM.