i have an Excel sheet with the time format 12:39:57 PM and i need to reset all the seconds to zeros to be 12:39:00 PM in all cells

Try this: =A1-SECOND(A1)*0.0000115

Thanks alot it's working

After a little thought, I think a better formula to use would be: =A1-SECOND(A1)/86400

since 1/86400 is 0.0000115740740740741 not 0.0000115.

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History