Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting a number to hours and minutes
Thanks Alan, it worked perfect!!! d. :) -- dslocum |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Total Minutes and converting to Hours and Minutes | Excel Discussion (Misc queries) | |||
Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
Converting hours:minutes:seconds to just minutes | Excel Worksheet Functions | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions |