How do I add/subtract hours and minutes when some values exceed 2.

L

lhasalass

I am trying to set up a spread sheet whereby I can input a value relating to
hours and minutes (this value will be over 24 hours), and then other values
in hours and minutes (all under 24 hours) which I need to subtract.

I'm struggling to input a 'time' value which exceeds 24 hours.

Can anyone help?
 
L

lhasalass

Brilliant.

Thank you. It's easy when you know how!

Andy B said:
Hi

Try formatting the cell as [hh]:mm

--
Andy.


lhasalass said:
I am trying to set up a spread sheet whereby I can input a value relating
to
hours and minutes (this value will be over 24 hours), and then other
values
in hours and minutes (all under 24 hours) which I need to subtract.

I'm struggling to input a 'time' value which exceeds 24 hours.

Can anyone help?
Click to expand...
Click to expand...
 
Top