Format [m]

  • Thread starter Thread starter Paul Dennis
  • Start date Start date
P

Paul Dennis

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?
 
Multiply by 60*24 and it is the number 91

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display masking 2
Time calculus in Excel 2000 8
Nested IF Statement Help 4
Subtract 12 hours from date/time 6
Length of time from date/time custom format 2
countif question using two negative number criterias 3
Formatting 2
Add Cells error 2

Back
Top