1.

Solve : Excel formulas?

Answer»

I am woundering hw to log times in an excel SPREAD sheet. For example 16 min 34 sec(16:34) it shows up as a time meaning 4:34pm. When I have a 25 min time it shows up 25:00:00. All i want to do is have the 16:34 show up not antime in dayWhat version of Excel/Office are you using?

Have you tried LOOKING here and using help from the navigation menu on the left ot this page:

http://office.microsoft.com/en-us/excel/FX100487621033.aspxTry entering 00 for HOURS, before the minutes and seconds. In other words, enter 00:16:34 MAKE Excel display 16 minutes, 34 seconds.



Discussion

No Comment Found