Want2BExcel
Board Regular
- Joined
- Nov 24, 2021
- Messages
- 112
- Office Version
- 2016
- Platform
- Windows
Help me solve this.
The set-up is as follows.
A1 (weekday)
B1 (date)
D1 (time,start1)
E1 (time,end1)
F1 (time, catagory1)
G1 (time,start2)
H1 (time,end2)
I1 (time, catagory2)
I want to make a formula that count hours between 00:00-06:00 and 17:00-00:00 when time is entered in D1,E1,G1,H1
Ex: D1=00:00 E1=09:00 G1=22:30 H1=00:00 Result 7,5
I looked at a former tread about some ATM's but couldn't convert the formula to my needs.
Hope someone can help.
Regards
Kenneth
The set-up is as follows.
A1 (weekday)
B1 (date)
D1 (time,start1)
E1 (time,end1)
F1 (time, catagory1)
G1 (time,start2)
H1 (time,end2)
I1 (time, catagory2)
I want to make a formula that count hours between 00:00-06:00 and 17:00-00:00 when time is entered in D1,E1,G1,H1
Ex: D1=00:00 E1=09:00 G1=22:30 H1=00:00 Result 7,5
I looked at a former tread about some ATM's but couldn't convert the formula to my needs.
Hope someone can help.
Regards
Kenneth
Last edited by a moderator: