E
Emily
any suggestions?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Luke M
In the future, keep your subjet line short, and post the majority of your
question in the body.
SUM is used to add a range of cells together. If you want the time
difference between two cells, simply subtract them, and format cells as
h:mm:ss
=A3-A2
or
=TEXT(A3-A2,"h:mm:ss")
Where A3 is the later time, A2 is the first/earlier time.
question in the body.
SUM is used to add a range of cells together. If you want the time
difference between two cells, simply subtract them, and format cells as
h:mm:ss
=A3-A2
or
=TEXT(A3-A2,"h:mm:ss")
Where A3 is the later time, A2 is the first/earlier time.
S
Sean Timmons
seems this would require some more information. Are you summing more than 24
hours? If so, go to Format Cells and change to Custom formattiing, [h]:mm:ss
hours? If so, go to Format Cells and change to Custom formattiing, [h]:mm:ss
D
Dave Peterson
Maybe you just have to format the cell with the formula(s):
[hh]:mm:ss
If this doesn't help, you may want to explain what's going wrong.
[hh]:mm:ss
If this doesn't help, you may want to explain what's going wrong.
N
Niek Otten
<won't work>
How do you know?
How do you know?