Subtracting Date/Time
=B1-A1
format as [mm]
"Sapphyre" wrote:
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
|