Friday 24 August 2012

excel, how to get the Time value from a Timestamp value

excel, how to get the Time value from a Timestamp value? Or even from NOW() function? 

If we have the C2 cell with Timestame value, Time = C2-INT(C2)
In order to get only the time value from NOW() we have Time =NOW()-INT(NOW())

No comments:

Post a Comment