Working With Time in Excel

by Posted on

Q: Why can't I get my time to add up correctly in Excel?

When entering time in the cell don't forget it starts with hours. Using a 24 hour clock is best, no need to type "am or pm". Once you enter your time you can format the cell as needed and the formula will work. If you are only adding minutes and seconds, you still need the leading hours for the formulas and formats to work.

Facebook Comments

Published by Julie: Girl Friday

A 'go to' girl who will help you get things taken care of; I have been working in construction since 1988, with a General Contractor as well as Subcontractors and suppliers. Where ever I go I am the go to person for setting up new space and organizing the flow.

Post a Memo

%d bloggers like this: