Anybody how to create 32 minutes 18 seconds in excel (32:18)?

Question

I tried format cell-with the format mm:ss but when I typed 32:18 It change to 18:00?? How to format 32:18??
Thank you

Answer 1

simple just put prime ( ' ) in front of the numbers



type '32:18

Answer 2

Mr. always time writes as hour/min/sec. how can u write a time without hour. when u type 32:18 it take 32 hour 18 min our 0 second . so dear write Like



00:32:18



12:32:18



01:12:00



ok

Answer 3

Try format>Text to Columns



Should work.



Enjoy!

Answer 4

right click the cell and select Format command to choose what you need.

Answer 5

enter your fee required to be switched over in cellular A1 (formatted as text cloth or enter as such '2:40 seven) In cellular B1 enter here (all one line pls as YA breaks formula) =fee(LEFT(A1,seek(":",A1) -a million)*60+(MID(A1,seek(":",A1) +a million,2))) answer comes decrease back in seconds (excuse the pun). Will convert any style of minutes wisely yet no longer if entered as hours, minutes and seconds. HTH