Register
Log In
Unanswered
Home
March 5, 2017
Offline
Hi Expert,
i Have formula below
C2=MOD(B2-A2,1)
C3=MOD(B3-A3,1)
C4=SUM(C2:C3) format as [h]"hrs"
i have data below
A B C
start end hour
22:56 07:02 08:06
04:59 13:04 08:05
16 hrs
But my worker said not working,why?i think this ok
Hope this clear
please kindly give explaination
thanks
July 16, 2010
Offline
Hi Mey,
Appears ok to me.
Interesting approach. I've not seen it done like that before.
Perhaps you can ask your colleague for an example of where it doesn't work. Perhaps where the time spans more than 1 day/24 hours.
Mynda
Most Users Ever Online: 57
Currently Online: clark shao
15 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Md. Rahman
Lilian Vo
Jane Kumwenda
David Miller
Efe Onwochei
LynAnn Williams
Brandy Kriger
purna chandar
E K
velissa barr
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
