Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 2nd 09, 02:48 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 1
Default Converting a number to hours and minutes


Sorry, but I couldn't find exactly what I was looking for in any
previous thread.
I am using Excel 2007 on a Vista Business box.

I need to simply convert a raw number of minutes into Hours:Minutes
format.
We want to monitor the length of time spent on paticular tasks
throughout the day. From a drop-down list the end-user selects the
Task Category and then Tabs to the adjacent cell and manually enters
the number of minutes it took to perform the task. The end-user
repeats this process throughout the day for each task.
I have use a SumIf function to track the total number of minutes for
each task available on the drop-down listing. I need to convert these
SUMs to hh:mm. Example: 120 minutes would return 2:00 and 126 would
returen 2:06. Likewise, 45 would return 0:45.
Is this possible?

d.




--
dslocum

  #2   Report Post  
Old April 2nd 09, 04:47 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 492
Default Converting a number to hours and minutes

Divide the minutes by 1440 and format the cell as Time,

=126/1440 formatted as time = 2:06

Regards,
Alan.
"dslocum" wrote in message
...

Sorry, but I couldn't find exactly what I was looking for in any
previous thread.
I am using Excel 2007 on a Vista Business box.

I need to simply convert a raw number of minutes into Hours:Minutes
format.
We want to monitor the length of time spent on paticular tasks
throughout the day. From a drop-down list the end-user selects the
Task Category and then Tabs to the adjacent cell and manually enters
the number of minutes it took to perform the task. The end-user
repeats this process throughout the day for each task.
I have use a SumIf function to track the total number of minutes for
each task available on the drop-down listing. I need to convert these
SUMs to hh:mm. Example: 120 minutes would return 2:00 and 126 would
returen 2:06. Likewise, 45 would return 0:45.
Is this possible?

d.




--
dslocum


  #3   Report Post  
Old April 2nd 09, 04:53 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Converting a number to hours and minutes

You can use another cell to convert minutes to time.

=a1/60/24
and give it a nice number format (hh:mm:ss)





dslocum wrote:

Sorry, but I couldn't find exactly what I was looking for in any
previous thread.
I am using Excel 2007 on a Vista Business box.

I need to simply convert a raw number of minutes into Hours:Minutes
format.
We want to monitor the length of time spent on paticular tasks
throughout the day. From a drop-down list the end-user selects the
Task Category and then Tabs to the adjacent cell and manually enters
the number of minutes it took to perform the task. The end-user
repeats this process throughout the day for each task.
I have use a SumIf function to track the total number of minutes for
each task available on the drop-down listing. I need to convert these
SUMs to hh:mm. Example: 120 minutes would return 2:00 and 126 would
returen 2:06. Likewise, 45 would return 0:45.
Is this possible?

d.

--
dslocum


--

Dave Peterson
  #4   Report Post  
Old April 2nd 09, 05:02 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 69
Default Converting a number to hours and minutes

use following formula

=TEXT(A1/1440,"hh:mm")
--
HARSHAWARDHAN.S.SHASTRI

Pl do not forget to press "YES" button if post found useful.


"dslocum" wrote:


Sorry, but I couldn't find exactly what I was looking for in any
previous thread.
I am using Excel 2007 on a Vista Business box.

I need to simply convert a raw number of minutes into Hours:Minutes
format.
We want to monitor the length of time spent on paticular tasks
throughout the day. From a drop-down list the end-user selects the
Task Category and then Tabs to the adjacent cell and manually enters
the number of minutes it took to perform the task. The end-user
repeats this process throughout the day for each task.
I have use a SumIf function to track the total number of minutes for
each task available on the drop-down listing. I need to convert these
SUMs to hh:mm. Example: 120 minutes would return 2:00 and 126 would
returen 2:06. Likewise, 45 would return 0:45.
Is this possible?

d.




--
dslocum

  #5   Report Post  
Old April 2nd 09, 08:13 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 1
Default Converting a number to hours and minutes


Thanks Alan, it worked perfect!!!

d.




--
dslocum


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Total Minutes and converting to Hours and Minutes PSULionRP Excel Discussion (Misc queries) 5 April 11th 08 09:44 PM
Converting total minutes into hours and minutes in Excel colette Excel Worksheet Functions 11 December 26th 07 07:24 PM
Converting hours:minutes:seconds to just minutes Dan Vagle Excel Worksheet Functions 3 July 17th 06 11:20 PM
converting Days Hours & minutes into just minutes in excel Six Sigma Blackbelt Excel Discussion (Misc queries) 5 April 28th 06 09:45 PM
Problem converting Hours to Days, Hours, Minutes Zyzzx Excel Worksheet Functions 4 October 24th 05 04:19 PM


All times are GMT +1. The time now is 04:48 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017