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
|