Use the event Macro:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Intersect(Target, Columns("A:A")) Is Nothing Then Exit Sub
'Change Columns to your Required column
If Target.Rows.Count 1 Then Exit Sub

Application.EnableEvents = False
Target.Value2 = Int(Target.Value2 * 96 + 0.5) / 96
Application.EnableEvents = True
End Sub
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"David" wrote in message
...
Jim,
Thanks for the suggestion but I need to find a way or template that has an
easy way to insert date & time like the shortcut ctrl :
but only in 15 minnute increments from the actual time. ie 1/4 or 1/2
hour
increments.

I do a lot of project work and would like to be able to post it quickly in
a
log.
my window of available hours is 7:00 am to 7:00 pm.
If someone has a drop down list template or I'll make my own, this might
work easy enough.

"Jim May" wrote:

Format A1 containing Date and Time and enter 8/27/2007 8:00 AM
in Cell B1 enter =A1+(1/48) '48 for 1/2 hour use 24 for 1 hour



"David" wrote:

Does anyone have a suggestion or template with easiest way to enter
date/time
in excel for keeping track of project times by the hour?
ie. drafting log or simple work log but in hours and not simply days...
Thanks,
David