PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
The problem we’ll discuss here is to get the current time in Excel as we don’t have any function to find out the time directly.
BEFORE READING THIS ARTICLE , IT IS REQUESTED TO VISIT THE PART I WHICH DISCUSSES THE CONCEPT OF THE DATE AND TIME IN EXCEL FOR BETTER UNDERSTANDING.CLICK HERE TO VISIT.
The current time calculation is quite easy in Excel as we already have the functions which provide us the current time but indirectly.
We can make use of Now() function which gives the current date and time altogether and Today() function which gives the current date only.
Now as we know that we need the current time only, we can subtract Today() from Now(), the integral part would be subtracted and we would be left with the decimal part only which is the time.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE