Convert minutes (in decimal form) to hours (in decimal form)

**DonW** · 07-07-2016, 01:48 PM

I'm trying to convert minutes to hours....minutes are already in decimal............

Would I divide the minutes by 60 or by 1440?

A1 B1
Total Call Minutes Total Call Hours
57.2 =A1/60 or =A1/1440 ???

Thanks

**oeldere** · 07-07-2016, 02:02 PM

a1= 57,20 in decimals is normaly 34,32 minutes

b1 = the result is 0,572 in hours

**DonW** · 07-07-2016, 02:17 PM

maybe this will help???

**oeldere** · 07-07-2016, 02:21 PM

the answer is:

=A2/60

57,2 minutes equals 0,95 hour in decimals.

**DonW** · 07-07-2016, 02:26 PM

alrighty then.......thank you oeldere.

**oeldere** · 07-07-2016, 02:29 PM

You're welcome. We appreciate the feedback!

Thanks for the rep.

**XLPadawan** · 07-07-2016, 07:31 PM

divide by 60

Convert minutes (in decimal form) to hours (in decimal form)

LinkBack

Thread Tools

Rate This Thread

Display

Convert minutes (in decimal form) to hours (in decimal form)

Re: Convert minutes (in decimal form) to hours (in decimal form)

Re: Convert minutes (in decimal form) to hours (in decimal form)

Re: Convert minutes (in decimal form) to hours (in decimal form)

Re: Convert minutes (in decimal form) to hours (in decimal form)

Re: Convert minutes (in decimal form) to hours (in decimal form)

Re: Convert minutes (in decimal form) to hours (in decimal form)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to convert decimal into days, hours and minutes?

convert seconds to decimal minutes and hours

convert decimal time to hours & minutes

[SOLVED] Convert Decimal Hours into Hours and Minutes in HH.mn format

Convert Decimal Hours into Minutes

Convert 32:15 minutes to 32.25 decimal hours

[SOLVED] Convert Decimal hours and Minutes to minutes please.

Bookmarks

Bookmarks

Posting Permissions