Add time time to total time.

[Tricks420]

Hello,

I am tracking the amount of hours and minutes I work daily using =IF(OR(C11="",D11=""),"",((D11-C11)*1440)/60)

This gives me a return in hours and minutes. I have another cell F11 that I would like to add additional time into in minutes and have it added to the original total.

Here is the file, thank you in advance: Lieu Tracker.xlsx

[Kaper]

Column E does not give you hours and minutes. Moreover you changed formula there with subtaction of 80 minutes.
The formula returns hours and hundredths of hour, not hours and minutes. So in E6 you have 10.30 which is 10h18
If you have time used in minutes in (let's stay in row 6) written in F6 as 80 then formula in E6 shall read:

Please Login or Register  to view this content.

but if you have it written in F6 as 01:20:00 (so again 80 minutes) then in E6 use:

Please Login or Register  to view this content.

By the way, you can do all calculations using time being presented as "Excel time". Key to success if you want to present numbers hihgher than 24 hrs is using custom formatting

[hh]:mm - see Cell G4, where I changed formula to:

Please Login or Register  to view this content.

In copy of your sheet I tried to correct all calculations to use just time. the only exception is calculation of Accumulated days in K3

Change checkout in D15 to 2:04PM and observe changes in K3 (and J3 - here will be just one minute increase)

[Tricks420]

Thank you,

I am not sure if it is working though.

For example, line 6. I started at 630am and finished at 4:48pm for a total of 10 hours and 18 minutes. However the results in Total Time only says 8:58 minutes.

[Kaper]

I thought you wonted to deduct column F from D and C difference. If not change formula in Sheet 1(2) E13:
=IF(OR(C13="";D13="");"";D13-C13-F13)
to
=IF(OR(C13="";D13="");"";D13-C13)

or in sheet1 E6 from:
=IF(OR(C6="";D6="");"";((D6-C6-F6)*1440)/60)
to
=IF(OR(C6="";D6="");"";((D6-C6)*1440)/60)

of course in both cases the formula shall be copied down and up in column F

[Tricks420]

Hello,

Thank you again for your help, I have been using the file as you made it. Thank you.

I need a little more help. I added a column called "Additional Time". If I get home after finishing work, I may need to out in an additional time.

1) I would like to be able to enter the time in minutes eg. 54, 71, 120, etc in column F. What formatting do I use for that [hh]:mm??
2) I would like any time for that day over 8 hours to be added to the "Accumulated Hours" in cell K3.

Here is my file: Lieu Tracker - WIP.xlsx

[Toonies]

Okay you have me confused

why would you want sum weekly hours over 44:00 and daily hours over 8:00 together in K3 it doesn't make sense?

do you get my drift

[Kaper]

If you do not want to enter 02:00 but just 120 minutes then yoiu can either:

- format the cell(s) where you want to enter that time as [mm] and enter your time as 0:120 (unfortunately not just 120, because it will be 120 days ). It will be visible as 120 but taken to calculations as 02:00:00 (you will see it in formula bar when the cell is active).

or
- leave the cell in general format, and enter 120, but in formulas refering to that cell use F4/24/60 to have it as 0.083333 of day (1/12 of day).

I'd rather use this first method, but both will work.

[pommie.mike]

When I did this a while ago I wrote functions to convert times to minutes and then back to times. All times were stored as strings.

Mike.