multiply hours

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

Hello from Steved

10:15 multiply by 5 days = 56:15 (Hours)

Please what is the formula 10:15 (Hours)per day *5 days

Thanks in Advance
 
Hi
if the time is stored in A1 just enter
=A1*5
and format the resulting cell with the custom format [hh]:mm to prevent
a rollover after 24 hours
 
Hello frank from Steved

I put hh:mm as you point out [hh]:mm
Thanks for that.

-----Original Message-----
Hi
if the time is stored in A1 just enter
=A1*5
and format the resulting cell with the custom format [hh]:mm to prevent
a rollover after 24 hours

--
Regards
Frank Kabel
Frankfurt, Germany
Hello from Steved

10:15 multiply by 5 days = 56:15 (Hours)

Please what is the formula 10:15 (Hours)per day *5 days

Thanks in Advance
Click to expand...

.
Click to expand...
 
Back
Top