Transferring time value to next sheet

[Khaldon]

Reference to the attached excel sample work book, I need help please in a formula in C column that will result in time subtraction that falls in the same month only, any time result over the end of the month should be transferred to C1 of next month sheet.

Example, attached sheet shows 2:15 in C2 cell while it should reflect the :45 remaining until the end of JAN month sheet, the remaining 1:30 time value should be transferred to cell C1 of FEB sheet.

[Khaldon]

Any ideas please may be with the use of the if function.

[trucker10]

See attachment

[Khaldon]

I am sorry but to looks like I did not explain my need adequately.

What I need help with please is to add time values that bellowings to the same month sheet of C column, any time falls after 24:00 of last day of the sheet month should be included in the next month sheet time calculations values in cell C1 since it is the start of a new month time calculations.

So in my example attached work book, I am looking for to see for the giving example, time values: 45 in cell C2 of JAN sheet and 1:30 in cell C1 of FEB sheet since cell B2 of JAN month has only 45 minutes remaining to the end of JAN and the rest of the time subtraction result which is 1:30 should be part of FEB sheet time calculations placed in cell C1.

[trucker10]

try out to find the right formula

[Khaldon]

Thank you, the formulas in columns C and D of your last attachment workbook are what I am looking for, however is it possible in case the month is not the same in cell A and B to have the time different value result in this example 1:30 which is the result of the formula presently in cell D3 to be displayed in cell C1 of the next month sheet instead of cell D3, for this example cell FEB C1 should show 1:30.

[trucker10]

Find new attachment

[Khaldon]

I really appreciate your time, but unfortunately I couldn’t sort out your last formulas in the required months different tabs.

I don’t desire to have different month time value calculation on one sheet; I would like to have each month time sum calculation in a different tab, as my attachment since I already have other data on each month tab to display.

Is possible please to sort out the your given formula to have each month tab contains only the first three columns A, Bb and C?

[trucker10]

You workbook contains three sheets, JAN, FEB, MAR. 2 of them are empty

please give an example > manually entered, so we can find the formulas .

[Khaldon]

Referring to my attach sample workbook, I input the working date and time for a certain month in daily bases in order to have at the bottom of each month the total working hours for that particular month, until the time were working happen to start close to the end of one moth and end at the beginning of next month in row.
It is this time share data between two months that I would like to split so each month tab contains working times only for that particular month on the related month tab of the working book.
I may start inputting data for a certain month while the rest of the year months in sequence are completely blank.
I hope this will clarify the need to fill several months in advance.

[trucker10]

give a simple example ( woorkbook ) what you in FEb or want to see other months.
Normally we put everything together in 1 sheet .
formula other tabsheet

[Khaldon]

Finally with your help I managed to sort out your given formulas to fit in my workbook. However I am using an iPhone App called DocsToGo that I can synchronize with my PC, unfortunately the below two formulas have a functions that not supported by my iPhone App. I believe it is “EOMONTH”.

The following link has all the supported function of my iPhone App.
http://support.dataviz.com/support.srch?DocID=2310

Would you please modify the below two formulas to include a supported functions from the link above.

=IF(MONTH(DEC!G58)=MONTH(DEC!H58),"",DEC!H58-EOMONTH(DEC!G58,0)-1)

=IF(MONTH(G3)=MONTH(H3),H3-G3,(EOMONTH(G3,0)+1)-G3),"")

[Khaldon]

If there is no substitution to the EOMONTH function from the app link list of functions available on previous post link, any ideas please in how to rewrite the two formulas and end up with the same results.

[trucker10]

I have not Docs ToGo on my Iphone .
find a iphone forum