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
Try Format Cell A1 as Custom then hh:mmFormat Cel1 B1 as Custom then hh:mmFormat Cell C1 as Custom then hh:mm Enter in Cell C1 the formula B1-A1 then enter the formala B1-A1
As some of your times span midnight, in C1=MOD(B1-A1,1)Format your total cell as Custom [h]:mm
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.
OnePlus 5 review
Alice Saey's mesmerising animation for Dutch singer Mark Lotterman
iPad Pro 10.5in (2017) review
Comment booster votre iPhone ?
© Copyright 2017 IDG UK. All Rights Reserved.