Time formula
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" wrote in message
...
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.
|