LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 90
Default Time function =Now formula

Hello,

I don't think it's possible, because I look in all the books and searched
the Internet, but here is the function I would like to have.

Have a A1 cell with the value =NOW() to apply the current date in time in
that cell
Have a A2 cell that would display the A1 cell value minus 1 hour
Have a A3 cell that would display tha A1 cell value minus 15 hours

I basically need to ba able to see the curent hour (13:02) in the A1 cell
and see (12:02) in the A2 cell and (22:02) in the A3 cell.

Not possible, right ?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro / function text time to 24hr excel time passed midnight fortotaling hr's Russmaz Excel Worksheet Functions 2 March 6th 09 04:58 AM
Insert Function next to formula bar gives Run-time Error '50290' Nick Excel Discussion (Misc queries) 0 July 7th 08 03:41 PM
verify use of TIME Function, Find Quantity Level compare to time-d nastech Excel Discussion (Misc queries) 9 July 11th 07 01:58 PM
Question for about using IF formula LEFT function at the same time jlandes84 Excel Worksheet Functions 2 December 19th 06 09:00 AM
formula that calc the diff in time, with a less than function? Debbs Excel Worksheet Functions 1 November 3rd 05 07:23 PM


All times are GMT +1. The time now is 09:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"