Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.