LOGO
General Discussion Undecided where to post - do it here.

Reply to Thread New Thread
Old 01-03-2010, 08:29 PM   #1
sttrqiss

Join Date
Oct 2005
Posts
435
Senior Member
Default
I'm getting similar functionality. Try entering the time as 00:02:50 rather than just 02:50. That's the only way i seem to be able to fix this.
this is correct, when you format the cell to mm:ss it will only display what you have input into that cell

so for 2mins 50secs it will display 02:50 instead of 0hours 2mins 50secs which is 00:02:50

however

you still must input into the cell as 00:02:50, simply putting 02:50 into the cell Excel will think that is 2hrs and 50mins by default. whether or not you can change this behaviour I don't know.
sttrqiss is offline



Reply to Thread New Thread

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

All times are GMT +1. The time now is 05:00 AM.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.6.0 PL2
Design & Developed by Amodity.com
Copyright© Amodity