Timesheet

runrman007

New member
Joined
Dec 23, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
excel 2007
The timesheets at my work are confusing. On the right side of the decimal the time is expressed as decimals of 60 minutes. On the left side they are expressed in military format. 14.75 = 2:45 pm. I would like to convert the miltary/decimal time 14.75 time to standard time 2:45.
 
Use this formula

=TIME(INT(A2),MOD(A2,1)*60,0)
 
Back
Top