Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Excel does a lot of time calculations, treating the current time as a
distance from midnight. However, if all you want to add are two (or more) time intervals, and come up with the total time, it gets confused. For example, if you are adding time taken to accomplish several tasks, the individual times, such as 10 minutes, two-and-a-half hours, ... do not have anything to do with midnight. And if you add several time segments, you should see the entire amount, and not the remainder after 24 hour chunks are subtracted. This is not an esoteric requiement in calculations. However, I have had to resort to acrobatics to be able to accomplish such calculations. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel only calculates the confidence interval for a population . | Excel Worksheet Functions | |||
Does Excel support Time Zones? | Excel Worksheet Functions | |||
How to continuously update time in Excel? | Excel Worksheet Functions | |||
How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
time calculation excel | Excel Worksheet Functions |