Excel Formula Needed for Calculating Minutes

  Durko 14:06 10 Aug 09
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 09

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 09

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 09

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.

AMD Ryzen release date, specifications and features: Three CPUs from the Ryzen 7 range now…

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

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…