Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I add/subtract hours and minutes when some values exceed 2.
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? |
#2
|
|||
|
|||
Hi
Try formatting the cell as [hh]:mm -- Andy. "lhasalass" wrote in message ... 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? |
#3
|
|||
|
|||
Brilliant.
Thank you. It's easy when you know how! "Andy B" wrote: Hi Try formatting the cell as [hh]:mm -- Andy. "lhasalass" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding hours and minutes | Excel Worksheet Functions | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
add column of minutes, show total in hours & minutes | Excel Worksheet Functions | |||
calculate average hours and minutes | Excel Worksheet Functions |