| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Formula
Is there a formula that displays the current time? Now displays the date and
time. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time Formula
re-format yr cell to "hh:mm" and leave =NOW() in place
|
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time Formula
Change the cell format from General, or whatever it is currently set to, to
Time. "Té" wrote: Is there a formula that displays the current time? Now displays the date and time. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time Formula
You could do this...
=NOW()-TODAY() More than likely, this will display as a decimal value, so you will probably have to format the cell as Time. Rick "Té" wrote in message ... Is there a formula that displays the current time? Now displays the date and time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
| convert from percentage of time to time using complex formula in . | Excel Worksheet Functions | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
Hybrid Mode
