Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to add a time
7:00 AM 5:00 PM should = 10 hrs
However if i use the forumla posted by Oscar =SUM(I19-H19*24) I would get -6.291666667 Yikes |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to add a time
Assuming your calculation will always be within the same calendar day, try
this: =HOUR(H19)-HOUR(I19) "JohnC" wrote: 7:00 AM 5:00 PM should = 10 hrs However if i use the forumla posted by Oscar =SUM(I19-H19*24) I would get -6.291666667 Yikes |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to add a time
It should be
=(I19-H19)*24 -- HTH RP (remove nothere from the email address if mailing direct) "JohnC" wrote in message ... 7:00 AM 5:00 PM should = 10 hrs However if i use the forumla posted by Oscar =SUM(I19-H19*24) I would get -6.291666667 Yikes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering Times | Excel Discussion (Misc queries) | |||
time differences in a column | Excel Worksheet Functions | |||
Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |