Convert durations to days by unit label

A value of 90 can mean seconds, minutes, hours or days. The unit column decides.

What you'll make

In Excel: 90 Minutes becomes 0.062500 days.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1B8Reads the unit label for this row."Seconds"
2"Seconds",A8/86400Seconds: divides by 86,400, the seconds in a day.2.062500
3"Minutes",A8/1440Minutes: divides by 1,440, the minutes in a day.Not used for row 8
4"Hours",A8/24,"Days",A8Hours: divides by 24. Days stay as they are.Not used for row 8
5SWITCH( … )Uses the part that matches the unit label.2.062500

Read it left to right. Any other label says Review duration unit. Excel counts time in days.

=SWITCH(B8,"Seconds",A8/86400,"Minutes",A8/1440,"Hours",A8/24,"Days",A8,"Review duration unit")

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own durations. Paste each value and its unit (Seconds, Minutes, Hours or Days) into the green columns of the Template tab. The days fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Check every row has its real unit; never guess it from the size. Keep the results as plain numbers.

Microsoft's help: SWITCH function