Quizzes & Puzzles1 min ago
Excel Formulas
10 Answers
Hi
Does anyone know of a site where questions can be answered relating to excel formulas??
Does anyone know of a site where questions can be answered relating to excel formulas??
Answers
Best Answer
No best answer has yet been selected by humpomatics. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Not sure what you mean - is it that your answer is not appearing in the correct format or that the answer you are getting is not what you were expecting ?
What are you trying to do ? An example would be good ? Make sure also that the cell in which you want the answer to appear is also formatted correctly.
What are you trying to do ? An example would be good ? Make sure also that the cell in which you want the answer to appear is also formatted correctly.
Ok here goes
a b c d e f
1 07:45 12:30 13:00 17:30 09:15
2 07:45 12:30 13:00 17:30 09:15
3 07:45 12:30 13:00 17:30 09:15 =sum(e1:e4)
4 07:45 12:30 13:00 17:30 09:15
Unfortunately the answer in f3 should be 37:00 but always appears as 13:00:00
any idea as to what i'm dong wrong. All columns are formatted to show hh:mm:ss...
a b c d e f
1 07:45 12:30 13:00 17:30 09:15
2 07:45 12:30 13:00 17:30 09:15
3 07:45 12:30 13:00 17:30 09:15 =sum(e1:e4)
4 07:45 12:30 13:00 17:30 09:15
Unfortunately the answer in f3 should be 37:00 but always appears as 13:00:00
any idea as to what i'm dong wrong. All columns are formatted to show hh:mm:ss...