Forum Discussion
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...
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.
Hey, I eddited my post using pictures. Hopefully it tells you enough. It's in dutch though (datumverschil = datedif)
