Forum Discussion

Silke1510's avatar
Silke1510
Copper Contributor
Jun 02, 2019

exel

Hello 

i would like to record my working time in a table. how do i write the formula so that the total hours are automatically calculated?

1 Reply

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Enter StartTime and EndTime in Column A and B, respectively. Hours in Column C is simply EndTime - StartTime, format the 3 Columns as hh:mm.