Hi Harpreet Gujral
In cell c1 you can use formula like this
=IF(A1-B10,(A1-B1)*-1,A1-B1)
then select in format cell Time - Select hours (should be
37:30:55)
and D1 you have to put some trick to remind you that result will delay or
still have time
==IF(A2-B20,Delay(Hrs),Have time(Hrs))
Simple way may can help you.
Worawat
MyBlog! http://excelbeginner.blogspot.com
2010/3/6 Harpreet Singh Gujral harpreetguj...@gmail.com
Hi Group,
I have the following question:
I have two cells, both have the following formating. DD/MM/ HH:MM.
Suppose, CellA1 has time 11/12/2009 09:00 while cell B1 has the following
value 11/12/2009 10:00. Can we find a diff in cell C1. The actual
difference would be 1hr.
Actually, what i am looking at is, Cell A1 consists of my deadline, while
Cell B1 consists of the actuall time. All i want to know is that, what was
the time which it got delayed.
Thanks
Harpreet Gujral
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @
http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about
the learning and support from the group.Let friends and co-workers know they
can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe