Extract Date from now function without using formatting

[Umesh Chahar]

i have used a now function in which i am getting both date and time , now i want to seperate both date and time without using formatting and without using date and time function. For eg, i can divide , multiply this now function to get date out of it and time too.

 

[Somendra Misra]

Hi Umesh,

Use =INT(NOW()) to get date and =MOD(NOW(),1) to get time. Format accordingly.

Regards,

 

[Umesh Chahar]

Thanks somendra for sharing the solution , infact i got one more resolution,use TEXT function
11/5/2014 14:45
=TEXT(NOW(),"DD-MM-YY") for DATE
=TEXT(NOW(),"HH:MM:SS") for TIME

 

[Somendra Misra]

@Umesh Chahar

With TEXT function, you cannot do any calculation directly on the result and you have to convert the TEXT result into numbers by adding 0 or by -- operator.

Regards,