=TODAY()+B2-A2
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Waseem Saifi
Sent: Monday, September 30, 2013 3:29 PM
To: excel-macros
Subject: $$Excel-Macros$$ Difference between time
Dear Experts,
I want to know total working time basis on in time
Try This
=IF(A5B5,TEXT(A5-B5,[h]:mm:ss),TEXT(B5-A5,[h]:mm:ss))
On Mon, Sep 30, 2013 at 3:43 PM, Ravinder ravinderexcelgr...@gmail.comwrote:
=TODAY()+B2-A2
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Waseem Saifi
*Sent:* Monday,
Thank you so much Ravinder Aamir.
Regards,
Waseem Saifi
On Mon, Sep 30, 2013 at 4:18 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Try This
=IF(A5B5,TEXT(A5-B5,[h]:mm:ss),TEXT(B5-A5,[h]:mm:ss))
On Mon, Sep 30, 2013 at 3:43 PM, Ravinder ravinderexcelgr...@gmail.comwrote: