TIME math

[Gale Gorman]

Can anyone shed a little light on adding and subtracting time in a formula?

Gale Gorman
Houston

 

[JE McGimpsey]

See

http://cpearson.com/excel/datetime.htm#AddingTimes

 

[Steven M (remove dirt and invalid to reply)]

Je Tue, 10 Aug 2004 02:45:36 GMT, "Gale Gorman"

Can anyone shed a little light on adding and subtracting time in a formula?

Gale Gorman
Houston

Gale,

For starters, "1" in a date/time cell means 1 day. If you have two
cells that display time values, you can use a formula in a third cell
to subtract one from the other and multiply by 24 to get the
difference in hours. You'll need to format the third cell in General
or some kind of Number format for this to work.

I looked at this page, posted here by JE McGimpsey, and it's pretty
good.

http://cpearson.com/excel/datetime.htm#AddingTimes


--
Steve M - (e-mail address removed) (remove dirt for reply)

"If this is coffee, please bring me some tea. If this is tea,
please bring me some coffee."
- Abraham Lincoln

 

[FDDavis]

Just for grins

time in A1 is 23:00:00
time in B1 is 04:15:29
c1 is time difference between a1 and b1
formula in c1 =a1-b1
format cell c1 as custom and type in the
format bar as follows

hh" Hours ":mm" Minutes ":ss" Seconds"
This will display your results as follows
18 Hours :44 Minutes :31 Seconds

Hope this is helpfull it could be oversimplified but works for simpl
time calculation

 

[Gale Gorman]

That was too simple. Just had to custom format the result cell like so
[h]:mm

Thanks for the link.

Gale Gorman
Houston

"Steven M (remove dirt and invalid to reply)"

 

[Gale Gorman]

I bookmarked that site. He has some great stuff.

Thanks,

Gale Gorman
Houston