Thread: 90 min - 1:30
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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




Reply With QuoteReply With Quote