Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtracting times
Hi, and thanks
For the life of me I can't figure this out, and I know it's simple. in cell a1 have the time 09:22:45am in cell a2 have the time 09:23:55am I want to subtract and in cell a3 have the answer of 1:10 Do I have to format the cells as something else and not time? Thanks Much Bobby |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtracting times
=A2-A1
and format as h:mm -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bob" wrote in message ... Hi, and thanks For the life of me I can't figure this out, and I know it's simple. in cell a1 have the time 09:22:45am in cell a2 have the time 09:23:55am I want to subtract and in cell a3 have the answer of 1:10 Do I have to format the cells as something else and not time? Thanks Much Bobby |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtracting times
Thanks Bob
On Sat, 12 Jan 2008 12:14:16 -0000, "Bob Phillips" wrote: =A2-A1 and format as h:mm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting Times | Excel Worksheet Functions | |||
Subtracting times | Excel Discussion (Misc queries) | |||
Subtracting times | Excel Discussion (Misc queries) | |||
Subtracting Times | Excel Worksheet Functions | |||
Subtracting times. | Excel Programming |