cell properties. hours?

  • Thread starter Thread starter bobbych
  • Start date Start date
B

bobbych

hi

i need to create a setup where i input the running hours and mins for
component. This input will add to a diff cell which contains tota
running hours and mins.

eg hours used today=3:40 need to add this to total hours

total hours =11350:20

cell properties does not have a setup for hhhhh:mm only hh:mm
is it possible?
cheer
 
You can use [h]:mm as a custom format but this will still fall foul of
the limit in excel. The largest amount of time that can be entered is
9999:59:59
 

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

totaling time in 2 cells w/ total of hours worked in 3rd 2
years-months-days-hours 5
How do you put Days and Hours into total hours 11
Concerting total minutes to hours and minutes 7
Adding Hours & Minutes 2
Deducting minutes off running total 2
calculating time formula 3
Split hours and minutes in two different cells 4

Back
Top