G Guest Dec 4, 2003 #1 I am trying to create a time sheet to track my hours and pay. When the cell format is H:MM:SS, the data is correct but wrong format. When I change it to currenct the data changes. Any ideas?
I am trying to create a time sheet to track my hours and pay. When the cell format is H:MM:SS, the data is correct but wrong format. When I change it to currenct the data changes. Any ideas?
P Peo Sjoblom Dec 5, 2003 #2 To get a monetary value using time and payrate, =time*24*payrate assume you have time 16:00 in B2 and a payrate of $20 =B2*24*20 format as currency -- Regards, Peo Sjoblom Darrell said: I am trying to create a time sheet to track my hours and pay. When the Click to expand... cell format is H:MM:SS, the data is correct but wrong format. When I change it to currenct the data changes. Any ideas?
To get a monetary value using time and payrate, =time*24*payrate assume you have time 16:00 in B2 and a payrate of $20 =B2*24*20 format as currency -- Regards, Peo Sjoblom Darrell said: I am trying to create a time sheet to track my hours and pay. When the Click to expand... cell format is H:MM:SS, the data is correct but wrong format. When I change it to currenct the data changes. Any ideas?
