How to remove letters and minus 4 hours from current time?

**bjaekel** · 06-04-2022, 02:45 PM

Team, please ; need help! Thank you kindly in advance!

How to remove letters and minus 4 hours from current time?

Cell: 2022-05-31T16:58:44.907Z
Goal: Obtain the hour count of 16:58:44 (-) 04:00:00 = result

Thank you again

**6StringJazzer** · 06-04-2022, 02:48 PM

If the format is standardized and is always yyyy-mm-ddThh:mm:ss.mmmZ then

Formula:

Please Login or Register  to view this content.

Values as displayed

	A	B
1	2022-05-31T16:58:44.907Z	12:58 PM

Underlying formulas

	A	B
1	2022-05-31T16:58:44.907Z	=TIMEVALUE(MID(A1,12,8)) - TIME(4,0,0)

**6StringJazzer** · 06-04-2022, 02:50 PM

Please update your profile. For your Office version, open Excel, go to File, Account and see what version is shown. Also when you first start Excel you get a splash screen showing the version before the app fully opens.

How to remove letters and minus 4 hours from current time?

LinkBack

Thread Tools

Rate This Thread

Display

How to remove letters and minus 4 hours from current time?

Re: How to remove letters and minus 4 hours from current time?

Re: How to remove letters and minus 4 hours from current time?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Highlight current time in half hours using CF

Hours worked minus breaks and start finish time

Minus break time minutes off working hours

[SOLVED] calculate time in and time out minus lunch hours

[SOLVED] Formula to work out hours between 2 dates and times.. MINUS Out Of Hours

Excel 2007 : Formula for current time + hours

How do I add 12 business hours to the current date/time?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions