**How to convert between hours, minutes, seconds or days in**
https://www.extendoffice.com/documents/excel/820-excel-convert-hour-minute-second-date.html

Convert between hour, minute, second or day with functions. 1. Convert time between hour, minute, second, or day with conversion factor. As we known, 1 hour = 60 minutes = 3600 seconds =1/24 day. So we can convert the time measurement with multiplying these factors. Day: "day" measurement: using in formula Hour: "hr" Year: "yr"

**Day:** "day"

**measurement:** using in formula

**Hour:** "hr"

**Year:** "yr"

**DA:** 20 **PA:** 28 **MOZ Rank:** 99