Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Note that using Ctrl + colon will truncate the seconds, so even if the
computer's clock is 09:23:58 it will come out as 09:23:00. -- Regards, Peo Sjoblom "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... If you don't want to use NOW(), you can put current time into a cell with control-shift-colon, or current date with control-semi-colon, or both together with control-semi-colon space control-shift-colon. -- David Biddulph |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel calculation of duration in hours and minutes | Excel Worksheet Functions | |||
Enter Hours duration over 24 | New Users to Excel | |||
fx duration | Excel Worksheet Functions | |||
Duration | Excel Discussion (Misc queries) | |||
Duration | Excel Discussion (Misc queries) |