在Google电子表格中排除范围内的日期 [英] Exclude dates from a range in google spreadsheets

问题描述

我是Google电子表格&尝试按照以下方式排除Google电子表格中某个范围的日期。

我在范围（c2：c7）中有以下单元格：

4/9/2015 9:21:09

4/9/2015 17:50:24

4/10/2015 17:25:57

4/11/2015 17:07:00

4/13/2015 18:13:35

4/14/2015 17:00:58

我想排除所有日期，并希望在B2范围内：

9:21:09

17:50:24

17:25:57

17:07:00

18:13:35

17:00:58

我曾尝试使用regexextract函数，但不能成功，任何人都可以帮忙，我已经在下面的链接中提到过这个问题：

https://docs.google.com/spreadsheets/d/1tsmeLz_TZ_nm_1M40bzM7cKq9mU_FUeFxdsk0fnL6wo/edit#gid=0

解决方案

try：

  = ArrayFormula（mod（C2：C7,1）） 
  

其中C2：C7是带时间戳的范围。格式化输出为TIME的列（通过123按钮）

I am new to google spreadsheets & trying to exclude dates from a range in google spreadsheet in following way.

I have following cells in range (c2:c7):

4/9/2015 9:21:09

4/9/2015 17:50:24

4/10/2015 17:25:57

4/11/2015 17:07:00

4/13/2015 18:13:35

4/14/2015 17:00:58

I want to exclude all dates and want following range in B2:

9:21:09

17:50:24

17:25:57

17:07:00

18:13:35

17:00:58

I have tried using regexextract function but could not succeed, can anybody help please, I have mentioned this in following link:

https://docs.google.com/spreadsheets/d/1tsmeLz_TZ_nm_1M40bzM7cKq9mU_FUeFxdsk0fnL6wo/edit#gid=0

解决方案

try:

=ArrayFormula(mod(C2:C7,1))

where C2:C7 is the range with the timestamp. Format the column with the output as TIME (via the 123-button)

这篇关于在Google电子表格中排除范围内的日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！