| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Formula
If i need to know how many remaining minutes does column A have, what can i
add to the below formula? "Ron Rosenfeld" wrote: On Wed, 27 Feb 2008 06:17:00 -0800, Jessica wrote: I have Column A (Total time in Minutes) and column B (total time in hours). If column A is more then 60 minutes i would like it to add an hour to column B. I hope i'm explaining my self correctly =SUM(B:B)+INT(SUM(A:A)/60) If you want to also subtract the whole hours from column A, then: =MOD(SUM(A:A),60) --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
| convert from percentage of time to time using complex formula in . | Excel Worksheet Functions | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
Threaded Mode
