Prev: Calculate a ratio of two numbers to the total
Next: Counting specific letters in a cell
From: tnal on 3 Jul 2008 11:27
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
From: vezerid on 3 Jul 2008 11:33
=(A2-A1)*24

Format as General

HTH
Kostis Vezerides

On Jul 3, 6:27 pm, tnal <t...(a)discussions.microsoft.com> 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

From: Bob Phillips on 3 Jul 2008 11:40
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_cells)/60)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"tnal" <tnal(a)discussions.microsoft.com> wrote in message
news:D75068CB-5FD3-4F16-A06C-E503C977D3E4(a)microsoft.com...
>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


 | 
Pages: 1
Prev: Calculate a ratio of two numbers to the total
Next: Counting specific letters in a cell