From: Dottie on
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
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
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
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
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.
>> >