Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time now
I am using the function Now(), this returns the current date and time. If
there a way of using this function just to return the current time? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time now
Instead of using NOW() in a cell, replace it with MOD(NOW(),1)
Alternatively, if you have the NOW() formula in A1, then in B1 =A1 - INT(A1) Format as time. Hope this helps. Pete |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time now
"Pete_UK" wrote in message oups.com... Alternatively, if you have the NOW() formula in A1, then in B1 =A1 - INT(A1) Why not =MOD(A1,1) <G |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time now
Hi Pete
this returns the follwoing 00/01/1900 13:19 is there any way of it just returning 13:19 Many Thanks Lee "Pete_UK" wrote: Instead of using NOW() in a cell, replace it with MOD(NOW(),1) Alternatively, if you have the NOW() formula in A1, then in B1 =A1 - INT(A1) Format as time. Hope this helps. Pete |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time now
You need to format it as hh:mm as well as it is picking up the source cell's
format. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "Lee Crew" wrote in message ... Hi Pete this returns the follwoing 00/01/1900 13:19 is there any way of it just returning 13:19 Many Thanks Lee "Pete_UK" wrote: Instead of using NOW() in a cell, replace it with MOD(NOW(),1) Alternatively, if you have the NOW() formula in A1, then in B1 =A1 - INT(A1) Format as time. Hope this helps. Pete |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time now
You can also try this one:
=TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW())) The data that you get is the same as with the other solutions, but this comes directly formated as required: "Lee Crew" wrote: Hi Pete this returns the follwoing 00/01/1900 13:19 is there any way of it just returning 13:19 Many Thanks Lee "Pete_UK" wrote: Instead of using NOW() in a cell, replace it with MOD(NOW(),1) Alternatively, if you have the NOW() formula in A1, then in B1 =A1 - INT(A1) Format as time. Hope this helps. Pete |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time now
Hi Miguel
That was just what I was after. Many thanks Lee "Miguel Zapico" wrote: You can also try this one: =TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW())) The data that you get is the same as with the other solutions, but this comes directly formated as required: "Lee Crew" wrote: Hi Pete this returns the follwoing 00/01/1900 13:19 is there any way of it just returning 13:19 Many Thanks Lee "Pete_UK" wrote: Instead of using NOW() in a cell, replace it with MOD(NOW(),1) Alternatively, if you have the NOW() formula in A1, then in B1 =A1 - INT(A1) Format as time. Hope this helps. Pete |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time now
Bob,
I'd already given him a MOD function, so I thought I'd give him an alternative. Pete (Night Owl) <bg |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time now
OK I see, a philanthropic barn owl <ebg
Catch one for me, I'm off to the land of zzz's Bob "Pete_UK" wrote in message oups.com... Bob, I'd already given him a MOD function, so I thought I'd give him an alternative. Pete (Night Owl) <bg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hot key for time? | Excel Worksheet Functions | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
time entry with am/pm and no colons | Excel Discussion (Misc queries) | |||
Entering Times | Excel Discussion (Misc queries) | |||
time differences in a column | Excel Worksheet Functions |