Trying to record data next to date cells for today

DIZZYPOUND 1 Posts Friday March 2, 2018Registration date March 2, 2018 Last seen - Mar 2, 2018 at 02:07 PM - Latest reply: ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen
- Mar 2, 2018 at 02:50 PM
Basically what I am looking to do is to record the minutes and seconds of each call taken manually and then where the dates are, I want it to record the information - as I work during those dates. So yesterday it would've recorded the number of seconds spent on the phone and then it would've stopped recording that information in the respective cells when the day ended and go to the next cell in succession to record the respective day's data.

Does any of this make sense? I can figure out all of the other formulas for this sheet but this one. I'm not very Excel savvy but I've been trying to figure this one out for a couple days with no luck. Hopefully, someone can help me? Thank you!
See more 

Your reply

1 reply

ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen - Mar 2, 2018 at 02:50 PM
0
Thank you
You are using Excel to store data, that is not what it is intended to do. Not only that, I am confused by what you are trying to log, and what final product you wish to have when it is done. Are you wanting to calculate total seconds?
Respond to ac3mark