ms-access - Ms Access 如何将字符串 HH:MM 转换为数字或时间进行计算

Question

在我的 ms 访问查询中，我有一个名为 [Hours & Minutes] 的列。列值被视为 "(((tblA.TotalMins) &':'&(mid (tblA.TotalHours,4,2))) as [Hours & Minutes]"。它是一个字符串类型，我想对其求和所以我想将其转换为 HH:MM 格式进行计算或任何格式进行计算

标签： ms-access

Answer 1

Your expression doesn't make sense, as it seems to interchange hours:minutes to minuttes:hours.

If your field holds text like "22:45", this can easily be converted:

DateValue([TextTime]) As TrueTime

If you have a field for hours and another for minutes, use TimeSerial:

TimeSerial([TotalHours],[TotalMinutes],0) As TrueTime