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) |