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

Honor 9 Lite review

How Social Media has Propelled Political Graphic Design and Art in the Last Decade

The best kids apps for iPhone & iPad 2018

HomePod d’Apple : date de sortie, prix et fiche technique