SUM OF TIME

[OSCAR]

hOW DO i GET EXCEL TO ACCEPT THE INPUTS OF 2:00PM + 6:45PM AND SHOW A SUM OF
= 4.75HRS?

 

[Barb Reinhardt]

Let's say

A1 = 2.00 PM
B1 = 6:45 PM
C1 =(B1-A1)*24
Format C1 as a number with 2 decimal places

 

[OSCAR]

nOW HOW WOULD aDD ONE MORE HOUR FROM D1?

Let's say

A1 = 2.00 PM
B1 = 6:45 PM
C1 =(B1-A1)*24
Format C1 as a number with 2 decimal places

 

[OSCAR]

tHANKS i GOT THE ANSWER TO THE ADD.

Let's say

A1 = 2.00 PM
B1 = 6:45 PM
C1 =(B1-A1)*24
Format C1 as a number with 2 decimal places