Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtract times?
I'm so rusty at this! Could someone remind me how I get the difference
between two columns of Times please? I'm using familiar hours and minutes. Col A Col B Col C 12:04 12:34 00:30 <--- How do I get this '00:30'? 16:35 18:34 01:59 etc What cell format do I apply after typing in the data as say HH:MM? And what function do I use for the result in Column C please? -- Terry, East Grinstead, UK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtract times?
Hi Terry,
Am Tue, 31 Jan 2012 10:49:01 +0000 schrieb Terry Pinnell: Col A Col B Col C 12:04 12:34 00:30 <--- How do I get this '00:30'? 16:35 18:34 01:59 etc if start and end always in same day, then in C2: B2-A2 and format hh:mm If sometimes the end is on next day, then in C2: =MOD(B2-A2,1) and format hh:mm Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtract times?
Thanks Claus, understood.
-- Terry, East Grinstead, UK Claus Busch wrote: Hi Terry, Am Tue, 31 Jan 2012 10:49:01 +0000 schrieb Terry Pinnell: Col A Col B Col C 12:04 12:34 00:30 <--- How do I get this '00:30'? 16:35 18:34 01:59 etc if start and end always in same day, then in C2: B2-A2 and format hh:mm If sometimes the end is on next day, then in C2: =MOD(B2-A2,1) and format hh:mm Regards Claus Busch |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to subtract[difference] in TIMES?? | Excel Worksheet Functions | |||
How can I subtract and enter times in my charts? | Charts and Charting in Excel | |||
Subtract times and let result go negative | Excel Worksheet Functions | |||
How to subtract times i.e. 18:55 day1 from 03:03 day2 | Excel Discussion (Misc queries) | |||
excel should allow to add and subtract times | Excel Worksheet Functions |