Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate Time
This is probably really simple but here you go.
I'm trying to convert hours worked into actual time. If I worked 7.75 hours I want it to display 7:45 (7 hours 45 minutes). How can I accomplish this? I would like for this to calculate since I work by project and keep track of the minutes/hours I've spent working on that project. Changed Battery .25 (.25 being 15 minutes) Changed Tire 1.75 (1.75 being 1 hour 45 minutes) Checked Oil .25 Total: 2:15 Total Time Any help would be great... any SIMPLE answer is greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate Time
If 7.75 is in A1 and you want the conversion to be shown in B1, then
apply this custom format to B1 : [h]:mm and then in B1 enter this formula : =A1/24 B1 will then display 7:45 Neil |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate Time
Leave the values in the cells as you have them. That makes caluclations a lot
easier. Just change the cells' FORMAT to [HH]:MM This changes the way we SEE the data, not the data itself. the square bracket allows values of 24 or greater to be shown. " wrote: This is probably really simple but here you go. I'm trying to convert hours worked into actual time. If I worked 7.75 hours I want it to display 7:45 (7 hours 45 minutes). How can I accomplish this? I would like for this to calculate since I work by project and keep track of the minutes/hours I've spent working on that project. Changed Battery .25 (.25 being 15 minutes) Changed Tire 1.75 (1.75 being 1 hour 45 minutes) Checked Oil .25 Total: 2:15 Total Time Any help would be great... any SIMPLE answer is greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How calculate end time with beginning time plus formula minutes | Excel Worksheet Functions | |||
Excel 2007 calculate time between 2 date/time columns | Excel Discussion (Misc queries) | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
IF statement to calculate time usage in specific time bands | Excel Worksheet Functions | |||
how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) |