Data literacy · Excel · Timesavers · Top tip · Working with Data

#496 Add up more than 24 hours in Excel

This top tip helped me recently when adding up the duration of a number of videos for a project. The duration of the videos were in the 24 hour clock format and when I added the duration together the result was not as I expected.

The answer was to change the format of the cells from Time to a Custom number type –  [h]:mm;@ (if you can’t see this type, copy and paste the code into the Type box). This resolved the issue and my numbers added up as I expected.

 

 

 

 

Photo by Alina Grubnyak on Unsplash

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s