CrazyBandit
New Member
- Joined
- Feb 21, 2017
- Messages
- 3
Hello. I have a text string that represents a date and time that an employee has signed in. It is a long text string
[TABLE="width: 152"]
<tbody>[TR]
[TD="align: right"]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 152"]
<tbody>[TR]
[TD="align: right"]
(20170102205400) which represents 8:54:00PM 01/02/2017 I then have another time, punch out time:
[TABLE="width: 153"]
<tbody>[TR]
[TD](20170103070200)
I tried using the TIMEVALUE formula, and that did not work. Any ideas how I am to make a calculation of how many hours the employee has worked. NOTE: Sometimes they work overlapping days.
Any help is greatly appreciated.

[/TD]
[/TR]
</tbody>[/TABLE]
[/TD][TABLE="width: 153"]
<tbody>[TR]
[TD](20170103070200)
I tried using the TIMEVALUE formula, and that did not work. Any ideas how I am to make a calculation of how many hours the employee has worked. NOTE: Sometimes they work overlapping days.
Any help is greatly appreciated.


[/TD]
[/TR]
</tbody>[/TABLE]
[/TR]
</tbody>[/TABLE]