Prev: adding time in a work schedule
Next: Adding Fractions and Displaying as a percentage.
From: Dave Peterson on 29 Apr 2010 08:36
Just to add...

When I want to include the date and time in the cell, I use:

ctrl-;(spacecharacter)ctrl-:



FSt1 wrote:
>
> hi
> there is no formula that will display the time that is not volital meaning
> that it is keyed to the system clock and will update to the current time each
> time the sheet calculates formulas.
> the keyboard shortcut Ctrl + Shift + : will insert the current time(system
> clock) into a selected cell but that is a manual process.
> if that is not what you want, vb is about all that is left.
>
> Regards
> FSt1
>
> "karim" wrote:
>
> > hi,
> >
> > i want to create excel sheet wherein time has to be recorded multiple time.
> > Now() formula does not help and i don't want to use macro.
> > Pls Suggest

--

Dave Peterson
First  |  Prev  | 
Pages: 1 2 3
Prev: adding time in a work schedule
Next: Adding Fractions and Displaying as a percentage.