Hi,
Something like:
If Start Time < Finish Time Then Finish Time - Start Time - 24 Otherwise Finish
Time - Start Time
If Start time is A1 and Finish Time A2
If(A2http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorial
Dear Yasir Shahjee,
As for instance, 01-Mar-2010 is in Cell D3, Time '20:00 Hrs' in Cell E3,
02-Mar-2010 in F3 Cell, Time '08:00 HRs' in G3, Then Put a simple formula:
(G3-E3)+(F3-D3).
Select the time format from Cell Properties Option and there you go.
This should solve your querry. if not
