entering date/time in 1/4 or 1/2 hour increments?
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
|