Current Time formula

BenNV · May 9th, 2002, 08:54 AM

I'm using =Now() to find the current date and time. But I only require the current time. Can we use a formula or VBA to do this? I want the time to be unchangeable everytime the workbook calculates.

Mark W. · May 9th, 2002, 09:06 AM

If you're only concerned about the display of a time value just apply a Time format to the cell containing NOW().

If you want to use just the time component of NOW() in a calculation use =MOD(NOW(),1) and apply a Time format.

[ This Message was edited by: Mark W. on 2002-05-09 08:08 ]

BenNV · May 9th, 2002, 09:09 AM

Thanks Mark. I still don't quite follow how to get rid of the date. Using the formula u gave I still get the date.

Mark W. · May 9th, 2002, 09:10 AM

Quote:

On 2002-05-09 08:09, BenNV wrote:
Thanks Mark. I still don't quite follow how to get rid of the date. Using the formula u gave I still get the date.

"If you want to use just the time component of NOW() in a calculation use =MOD(NOW(),1) and apply a Time format."

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 08:54 AM	#1
BenNV Board Regular Join Date: Mar 2002 Posts: 160	I'm using =Now() to find the current date and time. But I only require the current time. Can we use a formula or VBA to do this? I want the time to be unchangeable everytime the workbook calculates.

May 9th, 2002, 09:06 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	If you're only concerned about the display of a time value just apply a Time format to the cell containing NOW(). If you want to use just the time component of NOW() in a calculation use =MOD(NOW(),1) and apply a Time format. [ This Message was edited by: Mark W. on 2002-05-09 08:08 ]

May 9th, 2002, 09:09 AM	#3
BenNV Board Regular Join Date: Mar 2002 Posts: 160	Thanks Mark. I still don't quite follow how to get rid of the date. Using the formula u gave I still get the date.