Thread: [Solved] How to connect value of cell and text
View Single Post
 
Old 03-02-2019, 06:48 AM
bosco_yip bosco_yip is offline Windows 10 Office 2016
Novice
  
Join Date: Feb 2019
Location: Singapore
Posts: 7
bosco_yip is on a distinguished road
Default
Try,

In A1, enter 7:00

In B1, enter formula :

=A1*24&"-"&A1*24+8

Regards
Bosco
Reply With Quote