M
Maurita
Hi, hope someone can help me. I've been searching and trying different
formulas for hours, but still have a problem figuring total time from
two time fields. I have a field called Start Time (D16), and an End
Time (E16), with a total Hours (G16). No matter what formula I use, I
am getting the wrong time. For example.
1. Formula: =(E16-D16)*24
Start Time of 10:00 pm - End Time of 10:30 PM - Returns a Total
Time of .50 (should be .30)
2. Formula: =IF(E16-D16<0,1-(E16-D16)*-1,E16-D16)
Same Time as in #1 above - Returns a total Time of .02 Hours
(should be .30)
I have checked the Start and End Time cell formats, and they are all
the short time (example, 1:30 PM). I have tried the Number and
Accounting formats for the Total Time field, but I get the same result.
What am I missing?
Thank you.
Maurita
formulas for hours, but still have a problem figuring total time from
two time fields. I have a field called Start Time (D16), and an End
Time (E16), with a total Hours (G16). No matter what formula I use, I
am getting the wrong time. For example.
1. Formula: =(E16-D16)*24
Start Time of 10:00 pm - End Time of 10:30 PM - Returns a Total
Time of .50 (should be .30)
2. Formula: =IF(E16-D16<0,1-(E16-D16)*-1,E16-D16)
Same Time as in #1 above - Returns a total Time of .02 Hours
(should be .30)
I have checked the Start and End Time cell formats, and they are all
the short time (example, 1:30 PM). I have tried the Number and
Accounting formats for the Total Time field, but I get the same result.
What am I missing?
Thank you.
Maurita