...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Wed, December 15, 2010 1:39:36 PM
*Subject:* $$Excel-Macros$$ Facing calculation issue using Time type in
excel
Hi All,
When I subtract 9:30 from 10:00 (Data Type :Time),all I get to see is
###.How do I go about resolving this issue.I require
: schreiner_p...@att.net
Sent: Mon, December 20, 2010 4:03:07 AM
Subject: Re: $$Excel-Macros$$ Facing calculation issue using Time type in excel
Could you please tell what if there is more than 1 day difference. Say A1 has
10/12/2010 09:00 and B1 is 20/12/2010 10:00, then put Formulae in C1 as
ABS
, Hours)
Paul
*From:* C.G.Kumar kumar.bemlmum...@gmail.com
*To:* excel-macros@googlegroups.com
*Cc:* schreiner_p...@att.net
*Sent:* Mon, December 20, 2010 4:03:07 AM
*Subject:* Re: $$Excel-Macros$$ Facing calculation issue using Time type
in excel
Could you please tell what
$$ Facing calculation issue using Time type in
excel
Hi All,
When I subtract 9:30 from 10:00 (Data Type :Time),all I get to see is
###.How do I go about resolving this issue.I require a positive number 0:30
inspite of the result turning out to be negative.
FYI
=(1-2)
Current
Hi All,
When I subtract 9:30 from 10:00 (Data Type :Time),all I get to see is
###.How do I go about resolving this issue.I require a positive number 0:30
inspite of the result turning out to be negative.
FYI
=(1-2)
Current Expecting
19:309:30
210:00 10:00
the display format to a
numeric format.
Paul
From: Bharghav Ramdas bhargha...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wed, December 15, 2010 1:39:36 PM
Subject: $$Excel-Macros$$ Facing calculation issue using Time type in excel
Hi All,
When I subtract 9:30 from 10:00 (Data Type :Time),all I