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.

http://img230.imageshack.us/img230/976/exceloq5.png

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

Thank you! :)

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

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