Hours and sum of hours
 

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

Hours and sum of hours
 

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

If this post helps click Yes
---------------
Jacob Skaria


"u650431" wrote:

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

Hours and sum of hours
 

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
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"u650431" wrote:

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