Hi

I've got a cell to work out the difference in time between two time values. For example, 06:30 - 05:30 gives me a value of 60 minutes (all cells formatted to time). All good so far.

The problem comes when I try to multiply a value against the 60. For example, 6 sessions * 60 minutes should = 360, but I keep getting 0.25. It's because it's converting the time to a number which gives 0.04.

Is there a formula that says to use the value shown, not the value behind the workings?

Hope this all makes sense!

Thanks
Richard