I am using Excel at work and I have a list of users' online times.
I get a total say
180:30:00, which is 180hrs 30 mins and 0 seconds.
I need to keep this cell as the time, but I want to work out how many sales per hour they have made, so I need another cell linking to the total cell. But I need the format to be in
The format I use for the
180:30:00 cell and all my times is
[H]:mm:ss. To get the time into decimal I was going to use the left middle and right formulas to break the time into 3 different cells and then do the
hour + minute/60 formula, but I have came across an issue.
When I click on the cell
180:30:00 on the top line where you can enter formulae I have
07/01/2001 180:30:00. So when I apply the left middle and right formula it picks up the date as well.
Can you please explain to me how I could change the format of the cell to lose the
07/01/2001 – or is it always there when you involve time at all?
I'm not at work so I can't post a screenshot right now.