G Guest Aug 18, 2005 #1 I need to convert a number stated in minutes into a format that reflects Hours and minutes. As an example: 722 minutes = 12 hrs 2 mins
I need to convert a number stated in minutes into a format that reflects Hours and minutes. As an example: 722 minutes = 12 hrs 2 mins
C Chip Pearson Aug 18, 2005 #2 Use a formula like =A1/24/60 and format the cell for Time. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Use a formula like =A1/24/60 and format the cell for Time. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
B Biff Aug 18, 2005 #3 Hi! Divide by 1440 and format the cell as [h]:mm A1 = 722 B1 = =A1/1440 Format B1 as [h]:mm To do it in place: Enter 1440 in an empty cell Copy that cell Select A1 Paste Special>Divide>OK Format as [h]:mm Biff
Hi! Divide by 1440 and format the cell as [h]:mm A1 = 722 B1 = =A1/1440 Format B1 as [h]:mm To do it in place: Enter 1440 in an empty cell Copy that cell Select A1 Paste Special>Divide>OK Format as [h]:mm Biff
D Dnereb Aug 18, 2005 #4 Tell you a secret The date/time is stored in a double. 1 day = 1 12 hours = .5 6 hours = .25 etc....
