General Discussion Undecided where to post - do it here. |
Reply to Thread New Thread |
|
![]() |
#1 |
|
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. 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. |
![]() |
Reply to Thread New Thread |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|