The date and time are important values to take in account for some of my reports but extracting this information, it happen that the cell contains also some words like CET, EST, etc. to indicate the time zone code so I need to remove it. The alternative option is to use the “replace” tool.
When I use the formula ?
When I need to display the date and time only to calculate for instance the duration of the incident. The fact to not use the “replace” tool but the formula, it is automatic and faster.
How to use the formula ?
The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".
How are the formulas ?
=DATEVALUE()
=TIMEVALUE()
=MID()
Put this formula:
=DATEVALUE(MID(B2,1,2)&"."&MID(B2,4,2)&"."&MID(B2,7,4))+TIMEVALUE(MID(B2,12,5))
First, the formula will get the date DATEVALUE:
Secondly, the time TIMEVALUE:
And last thing, don't forget to format the cell if not it will display a decimal number.
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...