Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In MS excel if I set a cell format as time (e.g. [h]:mm:ss) and then if I type any number N in that cell, MS excel assume that number as number of days since 1st Jan 1900 00:00:00. Is it possible to change this behavior and let MS excel interpret that N as number of minutes since 1st Jan 1900 00:00:00?

share|improve this question
    
I'm pretty sure you can't change the behavior - the integer portion of an Excel data value is the days in 1/1/1900, as you explain, and the decimal fraction denotes hours and minutes. Why not compute the minutes directly and then display them as you wish with a custom number format? – chuff Jun 19 '13 at 5:57
    
The easy option would be dividing the content of a helper cell by 1440. – TheUser1024 Jun 19 '13 at 7:23

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.