G
GLENDALECA
its a simple formula that subtracts one colum from another using dates.
=G3-B3
G3 is the final date and B3 is the first date. What im trying to do i
base these dates not on a standard 12am to 12pm day but on a 5am to 5p
day. I'm clueless as to how to even begin in that direction. Also Tim
is another factor which I would like to incorporate into my fina
total. SO basically it looks like this
A B C D
F G H
TITLE 1ST 2ND 1ST 3RD
2ND 4TH TOTAL
DATE DATE TIME DATE
TIME DATE
Row B, C, E, G all contain dates and rows D, F contain times. I need t
know how long it took from row B to row G based on a 24 hour perio
starting at 5pm and ending at 5pm.
hope that clarifys a littl
=G3-B3
G3 is the final date and B3 is the first date. What im trying to do i
base these dates not on a standard 12am to 12pm day but on a 5am to 5p
day. I'm clueless as to how to even begin in that direction. Also Tim
is another factor which I would like to incorporate into my fina
total. SO basically it looks like this
A B C D
F G H
TITLE 1ST 2ND 1ST 3RD
2ND 4TH TOTAL
DATE DATE TIME DATE
TIME DATE
Row B, C, E, G all contain dates and rows D, F contain times. I need t
know how long it took from row B to row G based on a 24 hour perio
starting at 5pm and ending at 5pm.
hope that clarifys a littl