Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I know this has been asked before, but I need a little bit more help.
Ok I have this situation: A B C D Start Date/Time End Date/Time Total Time Total Minutes 08/15/07 14:56 08/16/07 16:02 1 days 1:06 I use format custom mm/dd/yy hh:mm for column A and B and just enter the information. Column C I have formated custom hh:mm and use this formula =(DAY(B2)-DAY(A2))&" days "&TEXT(B2-A2,"hh:mm") It doesn't have to look like 1 days 1:06, but that's the only way I could get the date/time to subtract right when it's over 24 hours. But the problem with this formula is I can't figure out how to get column D to work. Is there a formula that I could use in Column D where the answer would be 1506 (total minutes) in my example above? Hope I explained that right. Thanks, Sapphyre |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtracting time in date format | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions |