dynamic time difference between first & last check in & check out

**jimsenthil** · 02-25-2025, 08:19 AM

Hi team, help me in solving the requirement

i want to calculate the time diff between check-in & last checkout dynamically. whenever the base is updated

Formula to Get First Check-in and Last Check-out Per Owner

**sweep** · 02-25-2025, 08:33 AM

Hi,

Your formula is correct, but the dates / times are stored as text, not numbers. You could convert them like this:

Formula:

=DATEVALUE(INDEX(TEXTSPLIT(B2,","),1))+TIMEVALUE(INDEX(TEXTSPLIT(B2,","),2))

dynamic time difference between first & last check in & check out

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

dynamic time difference between first & last check in & check out

Re: dynamic time difference between first & last check in & check out

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Check for repetition and check for first 100 words and check for first sentence

Time in and out with Check mark to check out

Check if range of time falls in another range of time and get difference

How to check if excel file is Checked Out in SharePoing Check Out, run code, Check In

Column to check the difference

Automatically check one or more check boxes when a parent check box is manually checked

check the difference between any two values

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions