请问EXCEL如何将hh:mm:ss的时间格式转换为6位数字，例如将08：16：06转换为081606格式。

发布网友 发布时间：2022-05-07 15:49

我来回答

共1个回答

热心网友 时间：2023-11-05 22:39

=IF(TEXT(C2,"HH:MM")>TEXT("23:59","HH:MM"),TEXT(C2,"HH:MM")-TEXT(B2,"HH:MM")+TEXT("00:01","HH:MM"),TEXT(C2,"HH:MM")+TEXT("23:59","hh:mm")-TEXT(B2,"HH:MM")+TEXT("00:01","HH:MM"))追问谢谢回复，不过试过了没有解决。注：把时间放在了A1单元格，B1单元格套入公式后结果为1。

热心网友 时间：2023-11-05 22:39

=IF(TEXT(C2,"HH:MM")>TEXT("23:59","HH:MM"),TEXT(C2,"HH:MM")-TEXT(B2,"HH:MM")+TEXT("00:01","HH:MM"),TEXT(C2,"HH:MM")+TEXT("23:59","hh:mm")-TEXT(B2,"HH:MM")+TEXT("00:01","HH:MM"))追问谢谢回复，不过试过了没有解决。注：把时间放在了A1单元格，B1单元格套入公式后结果为1。

热心网友 时间：2023-11-05 22:39

=IF(TEXT(C2,"HH:MM")>TEXT("23:59","HH:MM"),TEXT(C2,"HH:MM")-TEXT(B2,"HH:MM")+TEXT("00:01","HH:MM"),TEXT(C2,"HH:MM")+TEXT("23:59","hh:mm")-TEXT(B2,"HH:MM")+TEXT("00:01","HH:MM"))追问谢谢回复，不过试过了没有解决。注：把时间放在了A1单元格，B1单元格套入公式后结果为1。

热心网友 时间：2023-11-05 22:39

=IF(TEXT(C2,"HH:MM")>TEXT("23:59","HH:MM"),TEXT(C2,"HH:MM")-TEXT(B2,"HH:MM")+TEXT("00:01","HH:MM"),TEXT(C2,"HH:MM")+TEXT("23:59","hh:mm")-TEXT(B2,"HH:MM")+TEXT("00:01","HH:MM"))追问谢谢回复，不过试过了没有解决。注：把时间放在了A1单元格，B1单元格套入公式后结果为1。

热心网友 时间：2023-11-05 22:39

=IF(TEXT(C2,"HH:MM")>TEXT("23:59","HH:MM"),TEXT(C2,"HH:MM")-TEXT(B2,"HH:MM")+TEXT("00:01","HH:MM"),TEXT(C2,"HH:MM")+TEXT("23:59","hh:mm")-TEXT(B2,"HH:MM")+TEXT("00:01","HH:MM"))追问谢谢回复，不过试过了没有解决。注：把时间放在了A1单元格，B1单元格套入公式后结果为1。

热心网友 时间：2023-11-05 22:39

=IF(TEXT(C2,"HH:MM")>TEXT("23:59","HH:MM"),TEXT(C2,"HH:MM")-TEXT(B2,"HH:MM")+TEXT("00:01","HH:MM"),TEXT(C2,"HH:MM")+TEXT("23:59","hh:mm")-TEXT(B2,"HH:MM")+TEXT("00:01","HH:MM"))追问谢谢回复，不过试过了没有解决。注：把时间放在了A1单元格，B1单元格套入公式后结果为1。

热心网友 时间：2023-11-05 22:39

=IF(TEXT(C2,"HH:MM")>TEXT("23:59","HH:MM"),TEXT(C2,"HH:MM")-TEXT(B2,"HH:MM")+TEXT("00:01","HH:MM"),TEXT(C2,"HH:MM")+TEXT("23:59","hh:mm")-TEXT(B2,"HH:MM")+TEXT("00:01","HH:MM"))追问谢谢回复，不过试过了没有解决。注：把时间放在了A1单元格，B1单元格套入公式后结果为1。