Hours and sum of hours

U

u650431

I want to create a spreadsheet in which I record total number of hours spend
on a maintenance job whereby minutes less then 30 are rounded to half an hour
and more then 30 are rounded to the hour.

Eg : 5:30 should be displayed as 5.5; 2:15 should become 2.5. 4:45 should be
come 5.0.
Which function should I use to facilate entering the data?

Next I want to sum the total number of hours and minutes. Obviously, if the
sum of minutes if greater then 60 the number of hours should be increased.
Example : 15 hours and 90 minutes should become 16.5
 
J

Jacob Skaria

Try the below formul and format to general.
=ROUND(A1*24/0.5,0)*0.5

If this post helps click Yes
 
J

Jacob Skaria

For you second part; with the hours in A1:A10 try the below formula

=ROUND(SUM(A1:A10)*24/0.5,0)*0.5

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Days and Hours 8
sum hours and minutes with Excel 2000 9
convert time to 1/4 hours 2
Adding Hours Worked Correctly 3
sum hours minutes seconds excel 2003 1
Calculate time with a break and total hours 5
adding rows of hours and minutes to get a total 1
I need to total minutes into hours. (example: :30, :45: 15 = 1:3) 1

Top