Hi,
Anyone able to help with a formula in the missing column.
Time Formula.xlsx
Basically have times in fractions of an hour
1.25 = 1 hr 15 mins
1.5 = 1 hr 30 mins
1.75 = 1 hr 45 mins
and need to be able to convert either or to the other.
EDIT** The hours and minutes are not in a time format, they are just text so 1 hr 30 is just 1.3.
Bookmarks