LinkBack URL
About LinkBacks
Hi,
I have two dates in column A and B as below
A B
01-01-2012 08:49 01-12-2012 11:35
I want to find out number of days and hours between these two.
Can someone help me please.
Mayank
Hi,
I have two dates in column A and B as below
A B
01-01-2012 08:49 01-12-2012 11:35
I want to find out number of days and hours between these two.
Can someone help me please.
Mayank
End Date - Start date formatted as dd hh
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I used this =TEXT(B1-A1,"DD:HH") but it gave me 30:02 which is incorrect.
Maybe this: =(B1-A1)/(24+1/240) and format as [hh]:mm
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks