Minecrafter1005
New Member
- Joined
- Jul 18, 2022
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hi. I'm doing a project where I add up a certain amount of times and show the amount of times next to it.
(Total Hours is meant to say Total Time (mins))
Like this. However, instead of adding the amount of time, it adds what time of day it would be. I need to change that (eg. 1:00:00 + 1:00:00 = 2:00:00).
The second issue, is that I want to be able to fill series with the sum. The equation is
=SUM(F3:F3)
=SUM(F3:F4)
=SUM(F3:F5)
and so on, but I don't know how to fill in the series properly. And whenever I try to do it I get the error message that says "Formula Omits Adjacent Cells".
If anyone can help with this, it'd be much appreciated! Thanks.
(Total Hours is meant to say Total Time (mins))
Like this. However, instead of adding the amount of time, it adds what time of day it would be. I need to change that (eg. 1:00:00 + 1:00:00 = 2:00:00).
The second issue, is that I want to be able to fill series with the sum. The equation is
=SUM(F3:F3)
=SUM(F3:F4)
=SUM(F3:F5)
and so on, but I don't know how to fill in the series properly. And whenever I try to do it I get the error message that says "Formula Omits Adjacent Cells".
If anyone can help with this, it'd be much appreciated! Thanks.