Hi, You could perhaps use =NOW() +/- time difference/24 eg =Now()-(11/24) Regards - Dave
Date: Thu, 13 Nov 2008 15:04:09 +0530From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: $$Excel-Macros$$ Time Format HI All Greeting you all mebers , I have a problems in formula function . I want use =NOW() For India ,=NOW() for USA etc in sinle sread sheet how it will please suggest me Regards Alok Dbs _________________________________________________________________ Take a summer road trip with Windows Live Hotmail. Multiple prizes and the ultimate dream beach house! http://www.ninemsn.com.au/hotmailroadtrip --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
