Date and time

[Clayton L. Wilson]

I am not an avid Excel user
Here's what I need

In cell 1 I have the starting dat
In cell 2 I have the starting tim
In cell 3 I have the ending dat
In cell 4 I have the ending tim

I need a function that shows me how much time elapsed between starting and ending in the format of "days hours:minutes"

Any advice will be helpful. Thank you

 

[Frank Kabel]

Hi
try the following
=INT(A3-A1) & " " & TEXT(A4-A2+(A4<A2),"hh:mm")

 

[Clayton L. Wilson]

Thank you. It's just what I needed