Time formula
in [Functions]
|
From: Dottie on 18 May 2010 11:41 Working with a spreadsheet (Excel 2007) that has a start time, end time and time Start Stop time 14:00 15:18 1:18 Would like to convert time to minutes and add 15 minutes to the answer. I have set up a custom format for minutes [m] but can't get the +15. Any help you can give me will be appreaciated.
From: RagDyeR on 18 May 2010 11:53 Try this: =MOD(B1-A1,1)+15/(60*24) -- HTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== "Dottie" <Dottie(a)discussions.microsoft.com> wrote in message news:38EC0DA2-5AF0-4BEB-80B6-8C9AB5F5B0B3(a)microsoft.com... Working with a spreadsheet (Excel 2007) that has a start time, end time and time Start Stop time 14:00 15:18 1:18 Would like to convert time to minutes and add 15 minutes to the answer. I have set up a custom format for minutes [m] but can't get the +15. Any help you can give me will be appreaciated.
From: Mike H on 18 May 2010 11:57 Hi, Try this =(B2-A2)+TIME(0,15,0) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Dottie" wrote: > Working with a spreadsheet (Excel 2007) that has a start time, end time and > time > Start Stop time > 14:00 15:18 1:18 > Would like to convert time to minutes and add 15 minutes to the answer. I > have set up a custom format for minutes [m] but can't get the +15. Any help > you can give me will be appreaciated. >
From: Dottie on 18 May 2010 14:06 Mike, thank you it works great. Now they want to convert the answer to minutes. I tried add [m] to formatting but get a really weird answer. Again, thank you in advance for your help. "Mike H" wrote: > Hi, > > Try this > > =(B2-A2)+TIME(0,15,0) > -- > Mike > > When competing hypotheses are otherwise equal, adopt the hypothesis that > introduces the fewest assumptions while still sufficiently answering the > question. > > > "Dottie" wrote: > > > Working with a spreadsheet (Excel 2007) that has a start time, end time and > > time > > Start Stop time > > 14:00 15:18 1:18 > > Would like to convert time to minutes and add 15 minutes to the answer. I > > have set up a custom format for minutes [m] but can't get the +15. Any help > > you can give me will be appreaciated. > >
From: Luke M on 18 May 2010 14:12 If you really just want a single digit answer: =(B2-H2)*24*60+15 Will convert the normal decimal value of time into a integer representing minutes. -- Best Regards, Luke M "Dottie" <Dottie(a)discussions.microsoft.com> wrote in message news:E78BBDBB-5034-4F1C-959F-4C2CEFE22B8C(a)microsoft.com... > Mike, thank you it works great. Now they want to convert the answer to > minutes. I tried add [m] to formatting but get a really weird answer. > > Again, thank you in advance for your help. > > "Mike H" wrote: > >> Hi, >> >> Try this >> >> =(B2-A2)+TIME(0,15,0) >> -- >> Mike >> >> When competing hypotheses are otherwise equal, adopt the hypothesis that >> introduces the fewest assumptions while still sufficiently answering the >> question. >> >> >> "Dottie" wrote: >> >> > Working with a spreadsheet (Excel 2007) that has a start time, end time >> > and >> > time >> > Start Stop time >> > 14:00 15:18 1:18 >> > Would like to convert time to minutes and add 15 minutes to the answer. >> > I >> > have set up a custom format for minutes [m] but can't get the +15. Any >> > help >> > you can give me will be appreaciated. >> >
|
Pages: 1 Prev: Find the last number in a row Next: Ability to sort data in Excel by fill color |