Thread: SUM OF TIME
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OSCAR
 
Posts: n/a
Default 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?