Prev: adding time in a work schedule
Next: Adding Fractions and Displaying as a percentage.
From: Jacob Skaria on 29 Apr 2010 01:01
Hi Karim

You cannot record the time automatically using formulas. You will have to
use VBA- worksheet/workbook events...

--
Jacob (MVP - Excel)


"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
From: FSt1 on 29 Apr 2010 02:23
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
From: Tom on 29 Apr 2010 03:23
If starting time is 3:20:35pm use the formula, =TIME(15,20,35)
and custom format the cell h:mm:ss AM/PM. Excel uses military time.

"karim" <karim(a)discussions.microsoft.com> wrote in message
news:3846658A-4C40-46C7-96FB-D5D8EDF6A3BC(a)microsoft.com...
>i want to record start time and end time multiple times on single worksheet
> without using macro. Pls suggest any formula for same as =now() does not
> help.
>
> karim.
>
>
> "ozgrid.com" wrote:
>
>> ????????????????????
>>
>>
>>
>> --
>> Regards
>> Dave Hawley
>> www.ozgrid.com
>> "karim" <karim(a)discussions.microsoft.com> wrote in message
>> news:1681BB59-DBF8-475C-B577-BE76CF17E9E5(a)microsoft.com...
>> > 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
>>


From: Tom on 29 Apr 2010 03:35
Another way. Use =NOW() to capture the starting/ending time. Then copy that
cell and paste itself as a value to freeze it and delete the date in front.

"karim" <karim(a)discussions.microsoft.com> wrote in message
news:3846658A-4C40-46C7-96FB-D5D8EDF6A3BC(a)microsoft.com...
>i want to record start time and end time multiple times on single worksheet
> without using macro. Pls suggest any formula for same as =now() does not
> help.
>
> karim.
>
>
> "ozgrid.com" wrote:
>
>> ????????????????????
>>
>>
>>
>> --
>> Regards
>> Dave Hawley
>> www.ozgrid.com
>> "karim" <karim(a)discussions.microsoft.com> wrote in message
>> news:1681BB59-DBF8-475C-B577-BE76CF17E9E5(a)microsoft.com...
>> > 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
>>


From: Steve Dunn on 29 Apr 2010 06:17
Another possibility if you are comfortable with Circular References:

In B1:

=IF(A1="",NOW(),B1)

Press F9 to force a re-calculation before entering data in A1, once data is
entered in A1 whatever was in B1 will stay there.



"karim" <karim(a)discussions.microsoft.com> wrote in message
news:3846658A-4C40-46C7-96FB-D5D8EDF6A3BC(a)microsoft.com...
>i want to record start time and end time multiple times on single worksheet
> without using macro. Pls suggest any formula for same as =now() does not
> help.
>
> karim.
>
>
> "ozgrid.com" wrote:
>
>> ????????????????????
>>
>>
>>
>> --
>> Regards
>> Dave Hawley
>> www.ozgrid.com
>> "karim" <karim(a)discussions.microsoft.com> wrote in message
>> news:1681BB59-DBF8-475C-B577-BE76CF17E9E5(a)microsoft.com...
>> > 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
>>

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