Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Yup, just tried that myself and voila! The *24 part threw me off...
"Toppers" wrote: =A1-B1 with cells formatted as hh:mm "jmj713" wrote: I did a search on this topic and the solutions given for some reason don't work for me. I need a simple formula that will give me a difference between two times (for instance, between 2:00 and 1:30 being 0:30). One formula I found was =(A1-B1)*24 but it did not work. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time difference calculation | Excel Worksheet Functions | |||
Average Time Difference | Excel Worksheet Functions | |||
Calculating time difference over midnight! | Excel Discussion (Misc queries) | |||
What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
Time / Formula to look at time difference | Excel Worksheet Functions |