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

dont multiply by 24 and format as hh:mm

Mangesh



"Maurita" wrote in message
oups.com...
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

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)
*24= hours
*24*60 = minutes
=(E16-D16)*24*60

You were close!
Mike F

"Maurita" wrote in message
oups.com...
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