Convert Min & Hrs to Min in Decimal
"Bruce Sinclair" wrote
in message ...
In article , "Peo Sjoblom"
wrote:
That's what I said, if it is formatting then the values are the same and
you
cannot use a function to
find a difference. I mean what difference do you see between
3:00
and
3:00:00
except that one is formatted for seconds as well, the underlying value is
still 0.125 and multiplied with 24 it will return 3
I was playing with this yesterday as it happens and yes, if you enter 3:00
it's effectively 3 hours.
Suggest if the OP want minutes, they need to use 00:03:00
Works for me. :)
If they already have data in a "wrong" format, as you suggest, they have a
problem :)
I agree he has to enter the first 2:00 and 3:00 in his example as 00:02:00
and 00:03:00 or else
it will be hours
--
Regards,
Peo Sjoblom
|