how in the world can I

[confused]

do this? I'm new to this board as well as excel. My problem is I'm trying to figure out a forumla that will give me a total time (hours & mins) but also use the date. such as, I have a job that starts on 4/8 1943 and ends on 4/9 2030. the forumla I have now only shows 47 mins. but such be 24hr 47 mins.
can anyone help me? TIA

 

[Yogi Anand]

Hi not confused anymore:
The earlier solution I gave you uses the Date and Time in the same cell -- that is in fact more efficient way of laying out the date and time. In Excel, date and time are integrated. However, we have to work it out whichever way your data is laid out.

Regards!

Yogi Anand