Excel problem

  dobie2 08:01 30 Jan 2010

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


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


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

Elsewhere on IDG sites

Samsung Galaxy S9 review

Explore Milton Glaser's iconic poster designs from the 1960s to present, including Bob Dylan, I…

What to expect at Apple's 27 March education event

Idées cadeaux pour geeks et tech addicts