SUM OF TIME
tHANKS i GOT THE ANSWER TO THE ADD.
"Barb Reinhardt" wrote:
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" wrote in message
...
hOW DO i GET EXCEL TO ACCEPT THE INPUTS OF 2:00PM + 6:45PM AND SHOW A SUM
OF
= 4.75HRS?
|