Excel help (time input)

Hello, I would like to ask if anybody in here is good in Excel.
I need to make a function that can add and subtract 15 minutes from a field that a user inputs time in.



Is this even possible in Excel?
All replies are much appreciated.

Thank you!

How ya doing, buddy?

I think the format you use is not accepted as a valid time. You can split input time into two cells, say start time on A2 and end time on B2.

Then for display one, put in:

=A2+15/60/24 for start time and
=B2+15/60/24 for end time.

For display two, simply subtract 15/60/24. In Excel time notation, 1 corresponds to "1 day," so 15 minutes is 15 / 60 (in hours) / 24 (in days).

(You can probably write a macro that does what you need, but this is the easiest way I know of)

Edit: Demo at http://spreadsheets.google.com/ccc?k...k-m-71PrhFNxBQ

There's nowhere I can't reach.

Wow, this is the first time I see Google Excel in action.
Thank you for your help!

Most amazing jew boots