ExcelBanter - time formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - time formatting (https://www.excelbanter.com/excel-discussion-misc-queries/245986-time-formatting.html)

Harry

time formatting

How do I convert 8.03 to 08:03 as time and how to calculate the table below

e.g.
Need to work 8 hrs per day
Time in Time out Difference Overtime
Due time
8.03 16.00 ??
?? ??
8.00 15.45 ??
?? ??

When an employee is absent

0.00 0.00 ??
?? ??

Gary''s Student

time formatting

With 8.03 in A1 use:

=TIME(INT(A1),100*(A1-INT(A1)),0)
--
Gary''s Student - gsnu200908

"harry" wrote:

How do I convert 8.03 to 08:03 as time and how to calculate the table below

e.g.
Need to work 8 hrs per day
Time in Time out Difference Overtime
Due time
8.03 16.00 ??
?? ??
8.00 15.45 ??
?? ??

When an employee is absent

0.00 0.00 ??
?? ??

All times are GMT +1. The time now is 02:30 AM.