Excel problem

  dobie2 08:01 30 Jan 10
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 10

=B1-A1

Format the result cell as Custom, d hh:mm

  dobie2 08:23 30 Jan 10

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

  VoG II 08:30 30 Jan 10

You type it into the box.

  dobie2 09:07 30 Jan 10

Thanks VoG, worked a treat

Debs

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…