| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Record time by formula
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Record time by formula
????????????????????
-- Regards Dave Hawley www.ozgrid.com "karim" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Record time by formula
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" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Record time by formula
What's you question? Don't be so vague...
-- Regards Dave Hawley www.ozgrid.com "karim" wrote in message ... 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" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Record time by formula
i want to create a worksheet where multiple data has to feed and each entry
should record its entry time. i dont want to use macro. Pls suggest "ozgrid.com" wrote: What's you question? Don't be so vague... -- Regards Dave Hawley www.ozgrid.com "karim" wrote in message ... 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" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Record time by formula
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Record time by formula
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Record time by formula
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" wrote in message ... 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" wrote in message ... 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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Record time by formula
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" wrote in message ... 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" wrote in message ... 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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Record time by formula
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" wrote in message ... 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" wrote in message ... 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 |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Record time by formula
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you print 1 record at a time per page? | Excel Discussion (Misc queries) | |||
| Formula that will record the time and date when an entry is made on a sheet | Excel Worksheet Functions | |||
| How do I record (.468) time in Excel without it rounding to .5? | Excel Discussion (Misc queries) | |||
| how do i record total editing time? | Excel Discussion (Misc queries) | |||
| time-sheet record with over 24 hours | New Users to Excel | |||
Linear Mode
