I
Iguana
Don't know if there is a function I should use for this:
Have one group of cells with data in hh:mm:ss format, copied from another
program, ie: 01:30:00
Have another set of cells which has an amount of time formatted as hh.hh
07.50
I want to subtract 1:30:00 from 07.50 (which should equal 06.00)
When I try to do it, because hh:mm:ss gets treated as the fractional part of
the date/time serial number, it is treated as 0.xxxx, and so the result
isn't 06.00.
Is there a function that can handle this conversion for me, or some formula
someone's is aware of to achieve what I am wanting?
Thx for any help.
Have one group of cells with data in hh:mm:ss format, copied from another
program, ie: 01:30:00
Have another set of cells which has an amount of time formatted as hh.hh
07.50
I want to subtract 1:30:00 from 07.50 (which should equal 06.00)
When I try to do it, because hh:mm:ss gets treated as the fractional part of
the date/time serial number, it is treated as 0.xxxx, and so the result
isn't 06.00.
Is there a function that can handle this conversion for me, or some formula
someone's is aware of to achieve what I am wanting?
Thx for any help.