**Convert Time Duration to Day, Hour, Minute in Google …**
https://infoinspired.com/google-docs/spreadsheet/convert-time-duration-to-day-hour-minute-in-google-sheets/

Mar 18, 2018 · That means I want to convert time duration to Day, Hour, Minute in Google Sheets. Here is that formula. Expected Result: 2 day (s) 4 Hour (s) 0 Minute (s) Example to find Day, Hours, Minutes from Time Duration. =int (C2)&" day (s) "&hour (mod (C2,1))&" Hour (s) "&Minute (mod (C2,1))&" Minutes (s)" Reviews: 8

**Reviews:** 8

**DA:** 38 **PA:** 81 **MOZ Rank:** 72