Thread
:
SUM OF TIME
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt
Posts: n/a
SUM OF TIME
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?
Reply With Quote