Excel Formula Needed for Calculating Minutes

  Durko 14:06 10 Aug 2009
Locked

What excel formula do I use to create individual and total minutes for the below. e.g. A1 is start time and A2 is 9:00pm with same B1 end time and B2 9:45pm etc. Time can be formatted 9:00pm or 21:00.

Start time End time
9:00pm 9:45pm 45min
10:40pm 11:15pm
9:40am 10:15am
10:45pm 11:35pm
11:40pm 12:20am
10:20am 12:45pm
7:30pm 9:00pm
11:30pm 11:50pm
11:50pm 04:50am
Total=

Any ideas very welcome and sorry for the waffle.

Durko

  Monoux 14:33 10 Aug 2009

Try

Format Cell A1 as Custom then hh:mm
Format Cel1 B1 as Custom then hh:mm

Format Cell C1 as Custom then hh:mm

Enter in Cell C1 the formula B1-A1 then enter the formala B1-A1

  VoG II 14:39 10 Aug 2009

As some of your times span midnight, in C1

=MOD(B1-A1,1)

Format your total cell as Custom [h]:mm

  Durko 15:58 10 Aug 2009

Thanks for your help Vog and Monoux, task sorted out now with your advice.

Durko

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

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?