[Solved] Calculate Night Rate in time tracking
Posted: Wed Mar 14, 2018 4:06 pm
Hi i'm a neewbie in OpenOffice but i'm trying to learn a bit more
My intention is track my work time that usualy start at 18h and end 04:00 but i got several times that i enter earlyer or late than 18:00
and the end is never 04:00 sometime is 02:00 or few times 08:00 or 09:00
My company pay me a night rate (an extra money) that goes beteewn 20:00 and 06:00 and i would like to separate the hours that i do between that interval of time
i'm using a calc sheet made by "Care 2 Shar care2share@calculatehours.com" and already made a few progresses but with my lak of aknowledge i'm stuck
when i start at earlyer, in time 18:00 or later i already manage to start counting after 20:00 , but when i leave later than 6:00 because is counting the hours after 06:00 and is not correct it should stop counting the night rate after 06:00.
I put in attach the file is not completed and someone check what is wrong
Thanks
Rodrigus
p.s- sorry my english but is not my natural language
My intention is track my work time that usualy start at 18h and end 04:00 but i got several times that i enter earlyer or late than 18:00
and the end is never 04:00 sometime is 02:00 or few times 08:00 or 09:00
My company pay me a night rate (an extra money) that goes beteewn 20:00 and 06:00 and i would like to separate the hours that i do between that interval of time
i'm using a calc sheet made by "Care 2 Shar care2share@calculatehours.com" and already made a few progresses but with my lak of aknowledge i'm stuck
when i start at earlyer, in time 18:00 or later i already manage to start counting after 20:00 , but when i leave later than 6:00 because is counting the hours after 06:00 and is not correct it should stop counting the night rate after 06:00.
I put in attach the file is not completed and someone check what is wrong
Thanks
Rodrigus
p.s- sorry my english but is not my natural language