Thread: Format [m]
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Format [m]

Multiply by 60*24 and it is the number 91

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Paul Dennis" wrote in message ...
|I have a cell that is formatted as [m] which gives the result of 91. I want
| to use this in a calculation as a normal number, but don't know how, i.e. I
| want to subtract 91 from another cell which isn't formatted as [m].
|
| How do I do it?