Software

Ask something
Discussion Locked

excel

0 helpful
2 replies

by chrispc616

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i am trying to add a column of times for a report that i am working on. my cell are as follows
E8 0:04:00
E9 0:04:24
E10 0:01:59
E11 0:02:54

I NEED TO HAVE A TOTAL OF TIME BUT EVERY FORMULA THAT I USE JUST COMES UP AND SAYS #VALUE.

2 replies

by charliespencer

It's possible the pair of colons is causing Excel to treat the times as text data, which you can't add with formulas. Try formatting all cells involved as a time format.

This discussion is closed to new replies.