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

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?