Excel problem

  dobie2 08:01 30 Jan 2010
Locked

Hi Guys

Looking for solution for the following

Column A has a date and time "05/Dec/2009 11:24" and column be has "08/Dec/2009 14:40".

I need column c to tell me howmany days, hours and minutes between the two days. Is this possible.

Love Debs

  VoG II 08:16 30 Jan 2010

=B1-A1

Format the result cell as Custom, d hh:mm

  dobie2 08:23 30 Jan 2010

Hi, there is not a d:hh:mm under custom ??

  VoG II 08:30 30 Jan 2010

You type it into the box.

  dobie2 09:07 30 Jan 2010

Thanks VoG, worked a treat

Debs

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017