I need help with a simple formula

R

Rick

I am trying to do a sum of a row of 8 cells (O5:V5) that contain hours and
minutes. If the sum is less than 24hrs it displays okay, if the sum comes to
more than 24hrs (ie 27hrs) then it only shows 03:00hrs as the total. All cell
formats have been set to the "Time" format. Can anyone help me please?
 
J

Jim Jackson

In the time settings of cell format there is a choice that shows greater than
24 hrs (37:30:55). I selected this one and performed the calculation without
problem.
 
R

Rick

Hi Jim, Many thanks. I will still have some hair left thanks to you.....
Cheers mate. Rick
 

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

TIME CALCULATION 8
formula for arriving net difference 0
Conditional Formatting with VBA 4
Formula appearing as Value in Formula Bar 1
Help, help! desparate for formula help!! 3
how do I add time worked over days/wks/mon greater than 24 hours 3
if cell is blank 8
Help in creating formula in a macro 2

Top