using the display value, not the true value

**richardlaw** · 02-14-2010, 04:58 PM

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

**teylyn** · 02-14-2010, 05:10 PM

Richard, how is your cell showing 60 formatted? What is the data type of that cell? If it's a time value, then you need to do something like

=(A1-B1)*60*24

and format to general. Then the result is the number 60 and you can use it for further calculations.

hth

**shg** · 02-14-2010, 05:28 PM

Or just format the result you have as h:mm, which will show 6:00 (6 hours)

**richardlaw** · 02-14-2010, 06:08 PM

Originally Posted by teylyn

Richard, how is your cell showing 60 formatted? What is the data type of that cell? If it's a time value, then you need to do something like

=(A1-B1)*60*24

and format to general. Then the result is the number 60 and you can use it for further calculations.

hth

Perfect, thanks!
Richard