Formula for adding time

D

Doug AllPool

Are all the cells formatted for time? I have them all formatted for time
(13:30) and
I get " #VALUE! " in the cell with the formula.

Doug
 
F

Fred Smith

If you get a #Value error, it means you don't have a time stored in the
cell. Formats change only the appearance of the cell, they don't change the
underlying data. To get a time, you have to enter it so Excel will recognize
it as a time. It must contain a colon; if you are using am/pm, there must be
a space in between, etc.

What are you actually entering in the cell?

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nita Time formula 1
Countdown macro - display settings 2
Copy addition formula of non-consecutive horizontal cells 2
Formula for adding time 1
Newbie Help - IF Yes No Function 0
How can the font and size of (all) citation numbers be altered? 1
Printing Outline view - formatting lost 0
Time Sum in Excel 1

Top