All articles with 'hour()' Tag

How to Calculate Working Hours Between 2 Dates [Solution]

Published on Sep 10, 2010 in Learn Excel
How to Calculate Working Hours Between 2 Dates [Solution]

This post builds on earlier discussion, How many hours did Johnny work? I recommend you to read that post too. Lets say you have 2 dates (with time) in cells A1 and A2 indicating starting and ending timestamps of an activity. And you want to calculate how many workings hours the task took. Further, lets […]

Continue »