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 `180.5`

.

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.}