Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Figuring and adding time in Excel
I have the start time in one column and the end time in another. Excel will
subtract the time in hours and minutes. This is great, but I want to show 2 hours and 30 minutes as 2.50, not 2.30. How can I make it show quarter hours, half hours, and three quarters of an hour so I can add the column to show total hours worked? -- tna |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Figuring and adding time in Excel
=(A2-A1)*24
Format as General HTH Kostis Vezerides On Jul 3, 6:27 pm, tnal wrote: I have the start time in one column and the end time in another. Excel will subtract the time in hours and minutes. This is great, but I want to show 2 hours and 30 minutes as 2.50, not 2.30. How can I make it show quarter hours, half hours, and three quarters of an hour so I can add the column to show total hours worked? -- tna |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Figuring and adding time in Excel
If you want to use it in calculations, you would need to split the hours
into one cell the minutes into another and use custom formatting to add the text. Sum with Mins: =MIN(59,SUM(range_minutes_cells)) Hours: ==SUM(range_hours_cells)+INT(SUM(range_minutes_cel ls)/60) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "tnal" wrote in message ... I have the start time in one column and the end time in another. Excel will subtract the time in hours and minutes. This is great, but I want to show 2 hours and 30 minutes as 2.50, not 2.30. How can I make it show quarter hours, half hours, and three quarters of an hour so I can add the column to show total hours worked? -- tna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Figuring time worked, and then separating it into regular time an. | Excel Worksheet Functions | |||
figuring total time | Excel Discussion (Misc queries) | |||
Converting from time format to decimal and figuring the difference | Excel Discussion (Misc queries) | |||
Figuring military time for total hours | Excel Worksheet Functions | |||
Adding time in Excel | Excel Worksheet Functions |