a2 = 8:52
b2 = 12:00
c2 = b2-a2

Steve

On Thu, 10 Aug 2006 15:06:02 +0100, Bobby
wrote:

Hi there,

I have a timesheet which works out working hours e.g. Time in 8:52 time
out
12.00 the answer is 3.13 so I then manually calculate the minute bit
0.13*60
which equals 8 minutes. Is there any clever way to calculate this to show
hours and minutes?

TIA



--
Steve (3)