Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate diff. between 2 times
I have followed "Help", but I'm not getting the right results, so something
is wrong. In cell H8 I have the formula =NOW() In cell K8 I typed 3-23 8:30 AM, formatted it as date and time, so it's giving me 23-Mar-09 8:30 AM. In cell K13 I have this formula: =K8-H8, and formatted the cell as "h:mm", which is giving me 21:05 at the moment. Well, between now, which is 11:25 AM 3/20 and 8:30 AM 3/23 is almost 69 hours. Why is it giving me 21 hours?? Thank you Connie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
plotting column chart whch colors the bars diff for diff comm | Charts and Charting in Excel | |||
SUMIF formula required to search for 2 diff values in 2 diff colum | Excel Worksheet Functions | |||
Summing up times by key words in diff column | Excel Worksheet Functions | |||
aps3 calculate diff in time and cinvert into another format | Excel Worksheet Functions |