time calculation, 24:00 - 16:00 = 8
You forgot to quote the relevant bits of the message to which you were
trying to reply, but if you want to convert 8:30 to 8.5, multiply by 24 and
format the result as general or number, not as time.
--
David Biddulph
DaveB wrote:
Ok..., this works. Thanks.
But:-)
In order to make calculations, i.e. sum totals of the product cells,
we need to keep the formats in time, i.e. 8:30 + 8:45 = 17:15 . What
I'm trying to do is convert the time formats into number formats. So
that total time 8hours and 30 minutes (8:30) results in a number 8.5.
|