Forum Discussion
ReinierB1715
Feb 21, 2022Copper Contributor
Calculate time difference
Hey, I'm currently struggling with something which will most probably be easy to solve. I've been using the formula =datedif for a longer time, but now I'm working with a new excel sheet and it...
SergeiBaklan
Feb 21, 2022Diamond Contributor
Show the date or number depends on format you applied, If that's a date. If you use text DATEVALUE() works if texts meets your regional setting formats. Perhaps something else, but that's better to discuss with sample or at least with screenshot.
- ReinierB1715Feb 21, 2022Copper ContributorHey, I eddited my post using pictures. Hopefully it tells you enough. It's in dutch though (datumverschil = datedif)
- HansVogelaarFeb 21, 2022MVP